I don't believe in this scenario that you need to use all of those options. Here is a modified query that returns the same result set. The sysdiagrams...

J-F Bergeron (2/9/2010)

---

Ehh, I wish I would've seen that comment before I posted the solution,

Why be so rude...

I agree, that one was over the top. Right at the top of the list for worst comments.

Nice article. Well written.

Ah yes. Robocopy making a comeback after so many years.

Alvin Ramard (2/9/2010)

---

CirquedeSQLeil (2/9/2010)

---

GilaMonster (2/9/2010)

---

george sibbald (2/9/2010)

---

I've never been more serious in my life. At last I can join in a discussion on an area where I am a real...

I'm still shooting for Boston. Hope to qualify some day.

I'll be watching for updates.

I knew that response was coming after I posted the question.

Many marathons and halves have I done. I used to run 5 full and 5 half marathons a year....

You will need to provide the data in a readily consumable format (the data that you are using) and the table structures. Your query is accessing different attributes/columns than...

Good luck. Marathons are a blast. Which 1/2 are you doing?

Steve Jones - Editor (2/9/2010)

---

Gary's argument for the award (and Jack's) are the problem I've seen with the MCSE, MCDBA, etc. over the years. HAving one doesn't mean you have...

arun.sas (2/9/2010)

---

Hi Janson,

Is there any direct convert method to get the year and week from date time?

I thought this code having...

causality

are you a marathoner?

george sibbald (2/9/2010)

---

surely that was asked...