Lynn Pettis (4/9/2009)

---

Any help on that thread would be welcome. Based on further information from the OP, I'm thinking something written using SMO may be a better option than...

GilaMonster (4/8/2009)

---

Anyone can,...

GilaMonster (4/10/2009)

---

I'll take that 'apology' with...

Chris Morris (4/10/2009)

---

Steve Jones - Editor (4/8/2009)

---

I'm not sure Jeff will get that one done, so someone else feel free to tackle it. He's agreed to start a nice T-SQL...

steve dassin (4/10/2009)

---

Jeff Moden (4/10/2009)

---

steve dassin (4/10/2009)

---

Just a note to say I'll be addressing some interesting responses from the discontinued thread:

T-Sql rant

http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx

Some of the responses were thoughtful and interesting, especially...

steve dassin (4/10/2009)

---

Just a note to say I'll be addressing some interesting responses from the discontinued thread:

T-Sql rant

http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx

Some of the responses were thoughtful and interesting, especially from Matt "The Dragon"...

I believe you need to ping back and say it was an error. Read the last post...

mzak (4/9/2009)

---

Indeed.

Is there any reason I should use one join over another? I agree that the inner join is the better choice here because (like you said) I'm simply...

Notice that the code window doubled up the word "ADD". That'll likely show up as an error if you copy the code.

andrew gothard (4/9/2009)

---

Jeff Moden (4/4/2009)

---

And, you're absolutely correct... some simple additions such as TRUNC(Date) would make life a bit easier. On the other hand, I hope to never see...

BWAA-HAAA! And, just as soon as I posted that, my code in your quote became the old purple window. Like you said, don't beat me, but I'm using...

How very strange... your screen shot of my most is as I saw it when I posted it. It's the new code window with colorized code and the whole...

The purple "windows" that your code is in on this thread is the "old" style and it worked well especially for people to copy from. The new code style...

Heh... somebody please tell me how you're managing to use the old code windows... I really don't like the new ones because of the errors they currently have in them....

leo4Ever (4/8/2009)

---

Yes, I agree with you Jeff. That's the reason I had mentioned this as a workaround rather than the best possible fix.

The final datetime value obtained from timestamp being...