Viewing 15 posts - 751 through 765 (of 2,443 total)
WayneS (3/10/2011)
jcrawf02 (3/10/2011)
*note to self - don't go to any meals with GusAw, he's not that bad!
...said Stumpy...
March 10, 2011 at 3:55 pm
We actually have annual contests to see who can guess the most acronyms, and we pass out a list to new hires so they're not completely clueless. Has over 200...
March 10, 2011 at 11:26 am
GSquared (3/10/2011)
Brandie Tarvin (3/10/2011)
Two years ago, we implemented a new process that uses the acronym "RI". I've been working on that process ever since. I've...
March 10, 2011 at 11:23 am
New blog post that makes this even better: http://sqlblog.com/blogs/john_paul_cook/archive/2011/03/09/when-the-obvious-answer-is-obviously-wrong.aspx
March 10, 2011 at 11:05 am
Have no idea if it really works, somewhat of a home-body, but bright lights are supposed to help reset your clock. Point the lamp at your head, or take the...
March 9, 2011 at 10:14 am
Steve, are you aware that you're sitting on a gold mine? Your barn could power Denver!
March 9, 2011 at 7:03 am
Kiara (3/9/2011)
Kit G (3/9/2011)
March 9, 2011 at 7:02 am
Aliasing with generic names is generally not best practice, I'll phrase it that way. It's not bad if you can keep track of which table does what, but in this...
March 9, 2011 at 6:31 am
bulbanos (3/8/2011)
basic math tells me both our equations are the same
Ah, well that's because I'm an idiot, and can't keep track of which table is which year (a case for...
March 8, 2011 at 3:27 pm
crookj (3/8/2011)
sing4you (3/8/2011)
CirquedeSQLeil (3/8/2011)
Daniel Bowlin (3/8/2011)
crookj (3/8/2011)
CirquedeSQLeil (3/8/2011)
Aggregateaggravate
abbreviate
alleviate
levitate
pontifulate
CHALLENGE! perhaps you were going for "pontificate"?
March 8, 2011 at 3:03 pm
Not following you on that one, my resultset might have confused things a bit, since it makes it look like the Feb 2011 value is 92. In fact, Feb 2010...
March 8, 2011 at 3:01 pm
Basically, it's comparing each parameter value to the resultset. Since you're doing NOT IN(), it's in essence checking for param1 <> record AND param2<>record AND param3<>record AND param4<>record.
When any...
March 8, 2011 at 2:52 pm
Craig Farrell (3/8/2011)
kd11 (3/8/2011)
The logic work but I had to change "-30" to "-60" to get within the last 30 days, I wondere why?
:blink:
CloseDate between GETDATE() -30 and GETDATE()...
March 8, 2011 at 2:46 pm
Are you asking how to get pirated copies of this $599.00 product for free?
March 8, 2011 at 2:19 pm
Viewing 15 posts - 751 through 765 (of 2,443 total)