Prev: Extra row in CTE
Next: See each of the steping through few rows to see how data gets
From: Plamen Ratchev on 29 Jan 2010 13:17
You can use the OUTPUT clause:

INSERT INTO @test
OUTPUT Inserted.machine, Inserted.plan_date, Inserted.plan_hrs
SELECT machine, DATEADD(dd, @days, '20100101'), 16
FROM @machines;

--
Plamen Ratchev
http://www.SQLStudio.com
 | 
Pages: 1
Prev: Extra row in CTE
Next: See each of the steping through few rows to see how data gets