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?
This is how you should do that:
INSERT INTO testTable (Id, Id2)
SELECT ID, ID2
from @t
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With