Viewing 15 posts - 2,371 through 2,385 (of 2,443 total)
So, for someone who is using 2000 still, but looking forward to 2005, EXCEPT will let me intersect the two sets, and give me the results that are not overlapping,...
---------------------------------------------------------
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."
July 30, 2008 at 10:42 am
Richard Gardner (7/23/2008)
What's orange and sounds like a parrot?
What's orange and sounds like a parrot?
---------------------------------------------------------
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."
July 23, 2008 at 7:49 am
webooth (7/23/2008)
True, but a CUSA can at least spell color. 😀
No no no, you SEE color, you don't spell it.
---------------------------------------------------------
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."
July 23, 2008 at 7:09 am
humbleDBA (7/11/2008)
CAGreensfelder (7/10/2008)
humbleDBA (7/9/2008)
Noli arrogantium iniurias pati. Vah! Denuone latine loquebar? Me ineptum.
I give - what's it mean?
The first sentence looks like "Be unwilling to arrogantly...
---------------------------------------------------------
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."
July 21, 2008 at 1:51 pm
Just curious, since I used something similar to your previous business day example in-house for a call center: When calculating your business time, how are you handling down-time? (or...
---------------------------------------------------------
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."
July 21, 2008 at 7:28 am
bnarav (7/16/2008)
---------------------------------------------------------
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."
July 17, 2008 at 6:54 am
I agree with both of you, and am about to spout something crazy - every part of the business affects every other part of the business.
I know! what...
---------------------------------------------------------
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."
July 2, 2008 at 6:53 am
Lynn Pettis (6/30/2008)
Peso (6/30/2008)
http://www.sqlteam.com/article/datediff-function-demystified
Peter,
I just took the time to read your article above. I wish I had know about it as I was doing my article, I would have...
---------------------------------------------------------
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."
July 1, 2008 at 6:56 am
Loner (6/26/2008)
---------------------------------------------------------
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."
June 27, 2008 at 9:26 am
Nah... "Must look eye!"... Sergiy doesn't need to know about all of that... he's trying to get you to go look back at your code to see why you don't...
---------------------------------------------------------
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."
June 27, 2008 at 8:34 am
Sergiy (6/27/2008)
jcrawf02,can you explain this:
ISNULL(count(distinct #PLANDATA_Claim.claimid),0) AS "FFS",What ISNULL is doing here?
I have three...
---------------------------------------------------------
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."
June 27, 2008 at 7:33 am
Jeff Moden (6/27/2008)
---------------------------------------------------------
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."
June 27, 2008 at 7:08 am
Thanks, I've seen you post that before, but never saved it (until now). 16 seconds (first run) on my system.
So, is the JOIN on ISNULL ok? Or is that...
---------------------------------------------------------
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."
June 27, 2008 at 5:51 am
Ian Crandell (6/26/2008)
Matt Miller (6/20/2008)
O.D.A.A ("other duties as assigned", another one of my pseudo job descriptions)
Matt - Have you worked in government? When I was in the Air Force,...
---------------------------------------------------------
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."
June 26, 2008 at 11:44 am
Don't know if you've made your decision yet, but I'd say pick the title that keeps the most of what you like doing, and leaves you career path opportunities, chances...
---------------------------------------------------------
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."
June 26, 2008 at 7:08 am
Viewing 15 posts - 2,371 through 2,385 (of 2,443 total)