Insert into table from table variable?

Question

DECLARE @t TABLE
(
ID uniqueidentifier,
ID2 uniqueidentifier
)

... insert into @t ... make stuff for @t

INSERT INTO testTable (Id, Id2) VALUES (SELECT ID, ID2 from @t)

- does not work?

+3

Shawn 08 Feb 13 at 13:43

2 answers

How about this?

INSERT INTO testTable SELECT ID, ID2 from @t

0

Sergio 08 Feb 13 at 13:45

gzaxx · Accepted Answer · 2013-02-08T13:44:38+0000

Here's how you should do it:

INSERT INTO testTable (Id, Id2)
SELECT ID, ID2 
from @t