Viewing 15 posts - 151 through 165 (of 667 total)
RBAR
CTE
rCTE
Edit: Added two more.
November 6, 2012 at 6:32 am
Tigers or Giants, doesn't really matter to me who wins. May it be a great series!
BTW, I still haven't understood why it is called the "World Series", if only North...
October 23, 2012 at 10:10 am
Nice one, Tom! But does the TRY_CONVERT() make the query non-sargeable? Guess it would?
October 15, 2012 at 9:38 am
May I ask why are you storing an integer as an nvarchar?
October 10, 2012 at 5:16 am
Grrrr!!! Seems I can't count properly on a Monday morning.
Good question though, Ron!
October 1, 2012 at 4:41 am
SQLRNNR (9/6/2012)
Stefan Krzywicki (9/6/2012)
Lynn Pettis (9/6/2012)
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
September 6, 2012 at 3:48 pm
RBarryYoung (9/6/2012)
Stefan Krzywicki (9/5/2012)
Fal (9/3/2012)
Quick poll: how would you pronounce the word "Route"?I'll explain why later, if I'm not too embarrassed. :blink:
Steve.
"Root" is the proper pronunciation as Nat King...
September 6, 2012 at 10:48 am
Just a question: Why would one want to pass a DATE to ISDATE()? Surely that should always return TRUE, even if it is NULL (which it doesn't if passed a...
August 28, 2012 at 4:04 am
venoym (8/14/2012)
...and we're now dealing with ICD9 to ICD10 conversion, ...
You are only now converting to ICD10? Those have been mandatory in South Africa (where I live) for the last...
August 14, 2012 at 1:48 pm
Liked that question, but had to scratch through BOL for a while to get it right, just because I haven't used the Express editions. I'm lucky to get to use...
August 13, 2012 at 4:07 pm
WayneS (8/12/2012)
For those that enjoy this sort of thing, here is a pretty good comparison of the various running totals methods available.http://www.sqlperformance.com/2012/07/t-sql-queries/running-totals
I did. Reminds me of looking up again when...
August 12, 2012 at 1:19 pm
Just back from our second winter practice. Feels great! If it wasn't for the first injury of the season by one of the first team players (badly hurt his left...
August 12, 2012 at 9:09 am
L' Eomot Inversé (8/11/2012)
Jan Van der Eecken (8/11/2012)
August 11, 2012 at 10:20 am
Coming back to the picture that was pulled due to being politically inacceptable. Could whoever posted it there please send me a PM with the link to the original one?...
August 11, 2012 at 5:13 am
Jeff Moden (8/10/2012)
...what would you use for a key that truly prevented such problems as those which arise in a merger?
We ran into that exact problem when our company in...
August 11, 2012 at 5:02 am
Viewing 15 posts - 151 through 165 (of 667 total)