Viewing 15 posts - 1,696 through 1,710 (of 2,443 total)
ok, so if I have a system generated UID from a different table, but the values are not entirely unique, only a few duplicates in my heap, I could/should use...
---------------------------------------------------------
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."
November 18, 2009 at 7:22 am
Thought I'd tell you, you guys are just fun to watch. 😉
---------------------------------------------------------
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."
November 18, 2009 at 7:18 am
Sujizulu - this is a really old thread, try looking here, especially in the discussion surrounding the article:
http://www.sqlservercentral.com/columnists/jmoden/calculatingworkdays.asp
Article is specific to workdays in the US, but the lengthy discussion may...
---------------------------------------------------------
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."
November 18, 2009 at 7:08 am
Can't help but chime in to agree with the excellent advice above. Boils down to "do you really want to work for someone who is doing this?"
Which may only be...
---------------------------------------------------------
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."
November 18, 2009 at 7:06 am
The function we're using in-house is from Jeff Moden, whose Tally table article Nigel already pointed you to. Uses that to achieve Proper Case (aka Title Case)
http://www.sqlservercentral.com/Forums/Topic530630-8-2.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."
November 18, 2009 at 7:04 am
Asking what is probably an obvious question, but from what I understand:
Adding a clustered index that covers multiple columns within a table is not necessarily advantageous, because it will expand...
---------------------------------------------------------
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."
November 18, 2009 at 6:53 am
Shoot, now I'm going to spend the rest of the week wondering just what category of white meat I fall into...
Thanks a lot...
---------------------------------------------------------
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."
November 18, 2009 at 6:23 am
S Hodkinson (11/18/2009)
MyHeadHurtsWhyDoWeHaveMeetings
Best answer I've ever seen: Because...
:hehe:
---------------------------------------------------------
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."
November 18, 2009 at 6:20 am
Bob Hovious 24601 (11/17/2009)
Have a nice trek, Lynn. Mind the shai-hulud.
:hehe:
---------------------------------------------------------
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."
November 17, 2009 at 12:55 pm
I'm confused, if we're talking about vines and clusters, shouldn't there be a bottle somewhere?
---------------------------------------------------------
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."
November 16, 2009 at 1:07 pm
My first thought was "why the intermediate step, why not just replace double occurrences of space with nothing?", but after testing it, it obviously doesn't work because you don't know...
---------------------------------------------------------
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."
November 16, 2009 at 7:25 am
CirquedeSQLeil (11/12/2009)
Alvin Ramard (11/12/2009)
CirquedeSQLeil (11/12/2009)
amazing how the thread can make a day go from bad to better. At least one good laugh a day.
At first I thought you said...
---------------------------------------------------------
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."
November 13, 2009 at 7:08 am
How about a medical concern?
Foot In Mouth disease...
---------------------------------------------------------
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."
November 12, 2009 at 1:12 pm
D'oh! Thanks for the correction, I was incorrect. Edited my previous post to indicate that, but left it in place so that your quote made sense in the context of...
---------------------------------------------------------
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."
November 12, 2009 at 12:08 pm
Bob Hovious 24601 (11/12/2009)
What chairs?Yes, I'm planning on being there.
ACK! Don't "Look Up" anything!!! :w00t:
---------------------------------------------------------
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."
November 12, 2009 at 10:47 am
Viewing 15 posts - 1,696 through 1,710 (of 2,443 total)