DECLARE @t TABLE
(
ID uniqueidentifier,
ID2 uniqueidentifier
)
…insert into @t
…do stuff to @t
INSERT INTO testTable (Id, Id2) VALUES (SELECT ID, ID2 from @t)
-does not work?
sqlsql-server-2008
DECLARE @t TABLE
(
ID uniqueidentifier,
ID2 uniqueidentifier
)
…insert into @t
…do stuff to @t
INSERT INTO testTable (Id, Id2) VALUES (SELECT ID, ID2 from @t)
-does not work?
Best Answer
This is how you should do that: