Well, I posted a link to a good article in the other thread. But since everyone is posting their code here, here's mine (very similar to you guys...)

DECLARE @demo TABLE...

I think that this article will guide you: Creating a comma-separated list (SQL Spackle)[/url]

SQLTestUser (3/2/2011)

---

I am sorry i should have had more details. I was trying to compare data and columns in two DB's where all the tables are identical but some...

Yes, definitely.

How's this?

/*

See how we take the test data and put it into a table?

Doing this really helps out all of the volunteers

(and some won't help if you didn't...

GSquared (3/1/2011)

---

Kiara (3/1/2011)

---

"I'm a...

Gag! That did it...

Thanks for the feedback on this... it...

CirquedeSQLeil (2/28/2011)

---

gregory.anderson (2/28/2011)

---

Great! Thanks for the help on this. Sorry about the brain-fart on the 'value' thing, I was out all last week sick with vertigo so that's my excuse....

Jonathan,

You're not using Julian dates/times in a format that I'm familiar with. What do you mean by a starttime of Julian 73?

(FYI: most people butcher up the real Julian format...

Good catch. Thanks!

krantkk (2/28/2011)

---

Hi All,

I am going to do side by step upgradation

my question is - can I upgrade sql server 2000 standard edition 32 bit to sql server 2005...

No problem. THANK YOU for posting the DDL/DML code for producing your environment - you went a long way in...

Just add the case statement used for building the OrderBy column into the ORDER BY clause itself:

DECLARE @today DATETIME;

SET @today = DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()),0); -- strip time from...

TravisDBA (2/23/2011)

---

The mindset of most managers will never support this at most companies. Most managers I know need to know you are on site to verify you are working. That...