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/

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...

Jeff?

Glad to share, Harold

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...

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...

mcphillipsjohn (12/17/2008)

---

Seth,

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...

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...

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,...

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...

Steve Jones - Editor (12/16/2008)

---

You can't get overwhelmed with all the new features. You have to pick the things that matter to you to learn. Is it worth investing in...

corey lawson (12/15/2008)

---

That's a good article, except for a couple of things.

Why do people still literally use commas as field separators (unless they have to, because the tool/function/utility doesn't support...

rahydri (12/15/2008)

---

Thankyou verymuch for the help. The function by Nicholas Cain works fine but the single line code by GilaMonster makes a mistake. it should convert time (with AM/PM...

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...

gcopeland (12/12/2008)

---

You said, "The march of technology makes bone-heads of us all." I take your meaning but I must disagree. The fact that changes in technology make our...

rbarryyoung (12/12/2008)

---

jcrawf02 (12/12/2008)

---

ALRIGHT! WHO HAS THE VOODOO DOLL!???

I'm blaming you guys - just went to pick up lunch and one of those delivery trucks with a steel bumper backed...