Viewing 15 posts - 121 through 135 (of 703 total)
This one looked familiar. Back in January, we were asked how many indexes could be applied to a SQL2005 table. Thanks for the reminder, not so much what...
October 6, 2011 at 10:00 am
hodgy (10/5/2011)
Ah, I was researching elemenTARTY keys, probably why I got it wrong 😉
I saw that too and looked for one of the choices to be "A must equal a...
October 5, 2011 at 9:50 am
Ed.Watson (10/4/2011)
Markus (10/4/2011)
Ed.Watson (10/4/2011)
Upton needs to stop getting picked off stealing.
scolded if you get caught... hero if you steal and score the winning run. He was trying to be...
October 4, 2011 at 3:48 pm
Fantastic QOD. Thank you!
For ease of reading here are what I considered the salient points in the MSDN posting. First, the important difference between table variables and temp tables:
While...
October 3, 2011 at 12:28 pm
Oh. Now I see what you meant by "duplicates". Yeah, a better way to have details and subtotals would probably be to have two SELECT statements, one for details and...
September 28, 2011 at 11:26 am
I'm glad to hear you have something that works for you. The "extra" NULLS in the result set could be made more understandable by adding GROUPING() functions to the...
September 28, 2011 at 11:19 am
I (and others, I'm sure) would rather not guess. Post the failing code so folks can give a crack at finding the problem.
September 28, 2011 at 10:00 am
1. To sum the sums, it's a lot simpler to sum the sum of each row. In other words, instead of trying to add CheckTotal and CashTotal, you could...
September 27, 2011 at 7:11 pm
Now that my Giants are out of it, I find myself rooting for St. Louis. Had to feel the Cubs fans's pain Saturday, though, when Marmol took the hill...
September 26, 2011 at 10:31 am
Gianluca's right about this in that variable substitution doesn't work here. Made me think about why. Let's look at the code that failed. It defines local variable...
September 22, 2011 at 10:56 am
Woo-Hoo! Should I be proud of myself as a developer (not a DBA) who knew this one without having to look it up? Yes, developers should know the...
September 8, 2011 at 11:18 pm
dallas13 (9/6/2011)
Not a very good question. We might not be aware of all these names, no matter how old we are.
Actually, I appreciate the question in that it made me...
September 6, 2011 at 1:32 pm
My guess would be that most people who missed this one, like me, didn't read the question carefully. If I'd paid attention to the "Choose Two" admonition, I'd have...
September 6, 2011 at 11:57 am
That's a great post, Tom, showing examples of the variety in calendar usage. It's truly fascinating in a way that appeals to my inner "geek". It also provides a...
August 10, 2011 at 7:28 pm
Ray K (8/10/2011)
How about . . . hmmmm thinkthinkthink . . . I dunno -- what ballpark has...
August 10, 2011 at 4:02 pm
Viewing 15 posts - 121 through 135 (of 703 total)