Thought I'd bring this to the water cooler. We talked to Kassondra again today, and she leaves reception tomorrow to actually start Basic Training. She sounded much better...

Tejas Shah (8/1/2009)

---

Hi,

Its better to use DATEADD(dd,0, DATEDIFF(dd,0,GETDATE())) instead of the conversion.

Because when you use this syntax fro order by, it will order t by date, while in VARCHAR, it...

Jeff Moden (7/31/2009)

---

NP... when I wrote it, it seemed crystal clear to me. Looking back at it, it's not so clear.

You have had a bit of a tough go...

Jeff Moden (7/31/2009)

---

Heh... not to worry, Lynn. It would appear that a good number...

Here is a mighty vague answer for a mighty vague question; It depends.

What are you wanting to test?

What is the data type of the column involved?

Not doing this much, what I'd suggest is that you start by reading about FOR XML in Books Online, the SQL Server help System.

This may make what you are doing...

How many times do you plan on posting this???

Multiple post, please post responses here.

Multiple post, please post responses here.

Multiple post, please post responses here.

Multiple post, please post responses here.

Jeff Moden (7/30/2009)

---

Thanks Lynn. I know where the EULA's are... I was trying to spike some curiosity on the part of the OP.

As a side bar, the...

venu_ksheerasagaram (7/30/2009)

---

Hi Friends,

Here i am facing a big problem. I need your ideas and advices to overcome this.

I am having a database in which its Data file (.mdf...

Thank you for demonstrating your lack of maturity. You obviously have continued to argue when there is obviously no way you will convice me you are right.

mtucker (7/30/2009)

---

Lynn Pettis (7/30/2009)

---

mtucker (7/30/2009)

---

Unfortunately that fact that there is no scientific proof that God exists DOES NOT mean he does not exist, as there is no scientific proof for...