That will work but it's pricey in performance compared to just adding the column.

I agree with Sean that the easiest solution for you is to add the additional column to store the old ID.

The OUTPUT clause can only access columns from the table...

The 😉 was intended to denote sarcasm, guys.

Grant Fritchey (6/5/2014)

---

Sean Lange (6/5/2014)

---

I am just going to leave this here...

http://www.sqlusa.com/bestpractices/%5B/url%5D

Don't worry there is soap for your eyes. Then if you read some of the content you may want...

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I),...

Koen Verbeeck (6/3/2014)

---

jasona.work (6/3/2014)

---

You know, I'd not really thought about this until now, but...

How do people find all these "undocumented" options for various SQL commands?

dbcc autopilot???

create index... WITH STATISTICS_ONLY =...

As Stevie Wonder once...

The composable DML looks interesting. I'm curious to look at it's execution plan and see how it performs with large batches.

An alternative I've seen involved a...

Would you care to elaborate why?

create table #TestData (Col1 varchar(20))

insert into #TestData

select 'aaa' union all

select 'bbb' union all

select 'ccc'

select stuff((select ','+Col1

from #TestData

order by col1

for xml path(''))

,1,1,'') as delimitedlist

Edited:

Whups, you were too...

Have a great summer, Steve.

Open the pod bay door, Hal....

http://www.visual-memory.co.uk/amk/doc/zg.html

Looks like it's been cleaned up already.

Wow. Talk about a blast from the past..... 🙂

+1 Good topic, good article, and good discussion. 🙂