Try the stuff function:

Select STUFF(

(SELECT ',' + a.columnA AS [text()]

from yourtable a

for xml PATH('')),1,1,'' )

Where columnA=123

Great topic. And now I have a bit of research and experiment to do.

Hungry

Jack Corbett (8/15/2011)

---

Stick at 75k...

Ditto

GilaMonster (8/15/2011)

---

Hmm, I can pick up 4 x 1 TB drives for around $300. RAID 5 config, 3TB internal. Should last for a while.

Or I can get 4 x...

Double that. Never...

GilaMonster (8/14/2011)

---

Plugin list:

Akismet - Essential. 99% eliminates spam.

No Self Pings - Doesn't send ping backs to own site (I reference earlier posts often and I don't like that producing trackbacks)

Now...

mulligan

I think it does make sense to do 450 after 432.

You're welcome. Stuff is concatenating the sequence of the hierarchy into a string.

I recommend finding what is causing all of that growth to occur and fix the process.

1 TB for tempdb is huge.

Here are a couple of articles you should read.

http://www.sqlservercentral.com/articles/Log+growth/69476/

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

When manually running, this seems to be the norm.

When run from a job, it will run the latest version.

If you know for certain that you no longer need the prior...

This will work better for you then.

With CatList (Child, Parent,IDNo, ParentIDNo, Clearance,sortkey) as

(Select ChildCategory, Category, IDNo, ParentIDNo,Clearance

,CAST('.'+CAST(idno AS VARCHAR(Max))+'.' AS VARCHAR(max)) AS sortkey

From Category

where parentidno is null

Union All

Select...

Same query i provided will yield these results.

Are you looking for indentation as well? It does not matter what order the data appears in the table - so long...