Could you add in a join against sys.dm_exec_requests on plan_handle?

I think that would get you access to the session_id

Great article, made for a very informative read. Many thanks!

thanks, I'll check out the link.

select email from Member usr

inner join Messages msg

on usr.ID = msg.UserID

where msg.IsRead = 0

Ok, so I'm presuming that there is a UserID column in the member table and that it...

yeah... their site doesn't mention the 2008 tests anywhere that I can find, I can only see info for 2005. I guess I could just call them. *shrug*

EDIT: ...

as a followup, where in the states can you even take the test? I used to go thru New Horizons but I cannot even find the test listed on...

definitely simpler than mine!

thanks!

My brain shuts off at the most inconvenient times 🙁

Thanks for the replies. I'll see if we can just get rid of it all.

sorry, I thought it was pretty universal that ... means too much stuff to bother typing out

plus I fixed a typo so it reads UPDATE instead of PDATE. It...

I'll play with it some more, not giving me the breakout im looking for. I need to figure out how to return a different value for 'period' when grouping...

Actually it was a 'pound head on keyboard' solution. I needed to put the CATCH/TRY inside the 2nd while loop instead of the while loop inside the CATCH/TRY.

anyone?

if you have any code samples for those login triggers, that would be a good starting place I think.

thanks!

thanks 🙂

I cobbled this together from an example but it doesn't give me the right -4.16

I have to account for the negative numbers and I hate doing math in SQL.

DECLARE @tblValues...