Viewing 15 posts - 16 through 30 (of 50 total)
Steve Jones - SSC Editor (2/21/2012)
antony-688446 (2/20/2012)
...
And those not in the US? We obviously don't exist 😉 Or our code will fail, queries never run, and the blooper reel won't...
February 22, 2012 at 1:16 pm
Quote: 'For those of you in the US, I hope your code compiles the first time, queries return quickly, and you enjoy the blooper reel I've compiled from the last...
February 20, 2012 at 1:10 pm
PartyPooper (1/5/2012)
Confused :unsure:
Read the thread... 🙂
January 5, 2012 at 3:48 pm
brazumich (11/10/2011)
SQL Kiwi (11/10/2011)
I can't believe I spent as much time as I did on this question.
Pretty much what I did (see my post earlier in the thread)....
November 10, 2011 at 1:40 pm
Looks like I am the first to get it right! 😀
Makes a change.
I am normally the last person to get it wrong.
Nice question, with lots of interesting articles.
October 26, 2011 at 9:48 pm
Ok, own question answered - compatibility level was set to SQL Server 2000 (80) (Don't ask me why, as I don't know...). Changed to 2005, and the query now executes...
September 6, 2011 at 4:20 pm
SQLRNNR (9/6/2011)
cengland0 (9/6/2011)
antony-688446 (9/6/2011)
September 6, 2011 at 4:08 pm
SQL Server 2005 SP3 - 9.00.4060 (which I can't find on MS's version list 🙂 )
September 6, 2011 at 4:01 pm
Hey guys - what am I missing?? I had 3 as failing, so was stumped that 1, 3 and 4 wasn't an option - I knew that 2 would work,...
September 6, 2011 at 2:42 pm
mohammadk-1135894 (6/30/2011)
June 30, 2011 at 11:08 pm
If the Q & A have been sorted, then 'Yesterday's Question of the Day' was missed from the clean up.... Double Doh! 😀
June 29, 2011 at 9:51 pm
Robert Davis (5/6/2011)
tbailey 19088 (5/6/2011)
Is this a joke??? I am a little bit socially challenged and I don't always correctly identify humor.
I love this reply!! This is by far the...
May 8, 2011 at 3:15 pm
I'm sorry, but I don't see the point of wrapping a perfectly useable & readable function with another one. Just adds unnecessary bloat and confusion.
May 5, 2011 at 10:18 pm
A useful script, that is nearly there, but not quite.
select dbo.dateceiling('2010-11-29 18:00:00.000','hh')
should return 2010-11-29 18:00:00.000 in the same way that select ceiling(1.00) returns 1
However, it doesn't - it returns 2010-11-29...
November 28, 2010 at 9:45 pm
Mauve (6/25/2010)
UMG Developer (6/25/2010)
Hugo Kornelis (6/25/2010)Please, people - NEVER USE CODE LIKE THIS IN PRODUCTION CODE!!!!
I agree, but I think variable concatenation is very commonly used, so it is important...
June 27, 2010 at 4:00 pm
Viewing 15 posts - 16 through 30 (of 50 total)