Viewing 15 posts - 46 through 60 (of 86 total)
Sr SQL developer (7/27/2012)
My comments are not intended to offend the author or the forum editor(s), but a clarification of my understanding of the purpose of the QOD.
FWIW, I, and...
July 27, 2012 at 7:35 am
D.Oc (7/27/2012)
"This is an opportunity to learn new/different thing and your answer will never be wrong if you Google it and read the...
July 27, 2012 at 6:41 am
Duncan Pryde (7/9/2012)
-- Query 1
SELECT...
July 9, 2012 at 5:39 am
sknox (7/2/2012)
Bob Razumich (7/2/2012)
July 2, 2012 at 11:54 am
For a moment, I thought the correct answer was a trick answer. "sp_refreshview"? It just seemed too cute for a Monday, but I looked it up first, anyway. Plus, I'd...
July 2, 2012 at 6:13 am
Nice question. I'm surprised there were votes for TCP/IP. Named Pipes, I can sympathize with that (for some reason I've never gotten along with that protocol).
December 9, 2011 at 6:32 am
SKYBVI (12/9/2011)
via is supported in sql server 2008 r2 ...Wrong question/answer
Regards,
Skybvi
It's the correct answer. Deprecated means it is going away in a future release. It's still supported but not recommended...
December 9, 2011 at 6:29 am
Good question, thank you.
I will "third" liking your question format. It forces us to actually type the code if we want to cheat that way before answering the question.
Or conversely,...
November 15, 2011 at 7:42 am
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). I...
November 10, 2011 at 12:52 pm
Good question. I'll be honest, I researched first, and Google pointed me to the entry vk posted in his earlier reply. I've never seen the sql_variant data type before.
Of course,...
November 10, 2011 at 6:48 am
With huge apologies to Ms. Shaw and Ms. Tripp...
I read the title "Odd Men Out" took a quick glance at the list, saw the names of two women, and decided...
September 6, 2011 at 7:18 am
rmechaber (7/11/2011)
Can someone explain to me why you might expect the SUM(CASE) construct wouldn't work? I use this all the time and thought it was pretty straightforward T-SQL.
Honest answer?...
July 11, 2011 at 7:58 am
Loner,
The only reason I changed jobs intentionally in my career was for heath reasons, both mental and physical. In that particular case, it was easy to take the pay cut...
July 11, 2011 at 6:48 am
Very good question. I saw the UNION part right away, but I admit I researched the CASE part first as I wasn't quite sure that would work in a SUM...
July 11, 2011 at 6:21 am
jeff.mason (5/24/2011)
George Carlin would have had a field day with this thread. After all, STUFF is what life is about.
And because there is never a bad time for George...
May 24, 2011 at 1:03 pm
Viewing 15 posts - 46 through 60 (of 86 total)