Viewing 7 posts - 1 through 7 (of 7 total)
SQLQuest29 (4/6/2011)
jwalker8680 (4/6/2011)
Comments posted to this topic are about the item <A HREF="/scripts/sp_who2/72823/">Capture and Alert for Blocked SPIDS with SP_WHO2</A>
Very good effort and nice script !
Just to add my 2...
April 8, 2011 at 7:26 am
Oops... See next post.
(PS> Anybody know how to delete your own post out here... <?>)
April 8, 2011 at 7:16 am
Excellent suggestions all... and all situations I never ran into 😉 ... Except maybe the length issue and I wasn't aware I was running into that issue... 😛
April 23, 2009 at 10:46 am
The code for figuring out the week of the month is built in SQL functionality... I don't know that there is a way, non-manual, to calculate week of month if...
April 23, 2009 at 8:23 am
Uh... dunno...
Not sure why you would want the first of the month to be the 19th... or vice versa...
I'm sure you have good reason for it... but I'm...
March 31, 2009 at 7:34 am
I could have taken the function down to a single line as well:
RETURN RIGHT(replicate('0',@TotalLength) + CAST(@Int AS VARCHAR),@TotalLength)
or.. SELECT RIGHT(replicate('0',6) + '1234',6)
...And I could use the code above instead of...
March 6, 2009 at 6:38 am
To simplify a few queries and add a little more functionality I have added a few new columns. [DOWInMonth] is the occurrence of that Day-of-Week in the month. ...
February 18, 2009 at 1:44 pm
Viewing 7 posts - 1 through 7 (of 7 total)