Viewing 15 posts - 2,206 through 2,220 (of 2,443 total)
If you need this type of info a lot, you could also consider a dates table. Recent article about building one.
http://www.sqlservercentral.com/articles/Date+Manipulation/65195/
---------------------------------------------------------
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."
December 18, 2008 at 7:44 am
jcraddock (12/17/2008)
It was originally written in ASP, but we re-wrote in in ASP.NET several years ago. We found going to c# to be very hours intensive, so we settled...
---------------------------------------------------------
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."
December 17, 2008 at 3:04 pm
RBarryYoung (12/17/2008)
Neat! Thanks for sharing, Jeff.
Jeff?
Glad to share, Harold
---------------------------------------------------------
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."
December 17, 2008 at 10:08 am
Thought you might like to see what I did, any suggestions welcome on making it better. Tried to KISS for the end user of this script.
Enjoy!
****Edit - I should...
---------------------------------------------------------
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."
December 17, 2008 at 8:03 am
Garadin (12/17/2008)
Actually, you can, old style joins use =* and *= for LEFT and RIGHT joins. That said, you *shouldn't*, as that is crazy confusing and I usually won'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."
December 17, 2008 at 7:10 am
mcphillipsjohn (12/17/2008)
3. I have noticed it's more common to use the JOIN keyword, I just learned it the other way and find it hard to break the habit. Maybe I...
---------------------------------------------------------
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."
December 17, 2008 at 6:58 am
Nice job explaining Seth - you only forgot one thing...
John, if you look at the link in Seth's sig (and mine, too, same article) you'll see samples of how to...
---------------------------------------------------------
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."
December 17, 2008 at 5:42 am
Hey Jano, thanks for writing the article. Unfortunately, I think some of the code is formatted incorrectly, as I could not see it in the article.
Also, your solution works,...
---------------------------------------------------------
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."
December 17, 2008 at 5:35 am
Jeff Moden (12/16/2008)Personally, I think everyone getting into computers should have to learn hand assembly of machine language using only a hex keypad and hex register display... just like I...
---------------------------------------------------------
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."
December 17, 2008 at 5:03 am
Steve Jones - Editor (12/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."
December 16, 2008 at 8:35 am
corey lawson (12/15/2008)
Why do people still literally use commas as field separators (unless they have to, because the tool/function/utility doesn't support...
---------------------------------------------------------
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."
December 16, 2008 at 8:31 am
rahydri (12/15/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."
December 15, 2008 at 9:33 am
Jeff Moden (12/12/2008)
I'm acutely aware that there are a number of tricks to being a highly productive SQL Programmer, and I cringe at the thought that I only know a...
---------------------------------------------------------
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."
December 15, 2008 at 6:46 am
gcopeland (12/12/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."
December 15, 2008 at 6:42 am
rbarryyoung (12/12/2008)
jcrawf02 (12/12/2008)
I'm blaming you guys - just went to pick up lunch and one of those delivery trucks with a steel bumper backed...
---------------------------------------------------------
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."
December 12, 2008 at 11:12 am
Viewing 15 posts - 2,206 through 2,220 (of 2,443 total)