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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 9, 2011 at 10:14 am
yes, that should work
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 9, 2011 at 8:51 am
Steve, are you aware that you're sitting on a gold mine? Your barn could power Denver!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 9, 2011 at 7:03 am
Kiara (3/9/2011)
Kit G (3/9/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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"?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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()...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 8, 2011 at 2:46 pm
Are you asking how to get pirated copies of this $599.00 product for free?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 8, 2011 at 2:19 pm
Viewing 15 posts - 751 through 765 (of 2,443 total)