Viewing 15 posts - 406 through 420 (of 1,193 total)
Hi, just remove the second 'where'.
Only 1 where per select in a query - combine conditions using and/or
July 10, 2014 at 5:34 am
sqldriver (7/7/2014)
Especially when I open up a 3000 line stored procedure,...
July 9, 2014 at 10:33 am
Koen Verbeeck (7/9/2014)
SQLRNNR (7/9/2014)
Koen Verbeeck (7/9/2014)
Grant Fritchey (7/9/2014)
Where does my data come from?Well the mommy data and the daddy data loved each other very much so....
He's being a tad lazy...
July 9, 2014 at 8:31 am
Toreador (7/8/2014)
Gazareth (7/8/2014)
Toreador (7/8/2014)
Being pedantic, only 3 of those statements return syntax errors...
Are you running it on SQL 2008 R2 or earlier?
Statement 6 is valid there but not on 2012...
July 9, 2014 at 3:23 am
Toreador (7/8/2014)
Being pedantic, only 3 of those statements return syntax errors...
Are you running it on SQL 2008 R2 or earlier?
Statement 6 is valid there but not on 2012 onwards.
July 8, 2014 at 6:43 am
Stuart Davies (7/4/2014)
Revenant (7/3/2014)
eccentricDBA (7/2/2014)
crookj (7/2/2014)
djj (7/2/2014)
BWFC (7/2/2014)
SQLRNNR (7/1/2014)
Kurt W. Zimmerman (7/1/2014)
djj (7/1/2014)
Revenant (7/1/2014)
crookj (7/1/2014)
Stuart Davies (7/1/2014)
Sean Lange (7/1/2014)
jcrawf02 (7/1/2014)
futbolDiving
scuba
Snorkeling
reef
reefer
USS
Sterrett
Alabama
Sweet Home
Freebird
Simple Man
Being There
(Peter) Sellers
Minky
July 4, 2014 at 5:41 am
"personality of a wolverine on double espresso"
I like that, I may steal it 🙂
All I can say on topic, is good luck!
July 3, 2014 at 7:29 am
djj (7/2/2014)
Gazareth (7/2/2014)
Of course, another...
July 3, 2014 at 4:59 am
Koen Verbeeck (7/3/2014)
Gazareth (7/3/2014)
Of course, if Super Brad Guzan had played then the US would have won 4-0 🙂Sure, keep on believing 😀
If Beneteke was playing, my loyalties may have...
July 3, 2014 at 4:42 am
Grant Fritchey (7/2/2014)
Did you hear, for a little while Tim Howard was listed on Wikipedia as the US Secretary of Defense. That's awesome.
Superb.
Of course, if Super Brad Guzan had played...
July 3, 2014 at 4:23 am
Andy Warren (7/2/2014)
Definitely not enough clues here if you don't know Kendal
No S**t Sherlock! 😛
July 3, 2014 at 4:18 am
Nice article Ed, much appreciated. Did not know some of these had also been introduced to 2008!
Cheers
Gaz
July 3, 2014 at 4:16 am
Good Q, didn't think much of the format if I'm honest though.
July 2, 2014 at 4:47 am
Found it on MS Connect - unfortunately it's been closed as won't fix (although allegedly will be kept in mind...)
The workarounds are SSMS Boost, Find/Replace or use ISNULL; all 3...
July 2, 2014 at 4:32 am
pharmkittie (7/1/2014)
Gazareth,What did you think of the policy that not even DBAs could use SSMS? Did your cousin suggest the DBAs use scripts and the command line?
It got shouted...
July 2, 2014 at 4:15 am
Viewing 15 posts - 406 through 420 (of 1,193 total)