Prev: See each of the steping through few rows to see how data getsappe
Next: Updating Bit fields over a linked server
From: Jack on 29 Jan 2010 15:08
Thanks Plamen for your help. It worked great.
Regards.

"Plamen Ratchev" wrote:

> 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: See each of the steping through few rows to see how data getsappe
Next: Updating Bit fields over a linked server