DECLARE @MyVar TABLE ( ID int )INSERT INTO dbo.TargetTable OUTPUT INSERTED.ID INTO @MyVarSELECt * FROM dbo.SourceTableSELECt * FROM @MyVar

DECLARE @MyVar TABLE ( ID int )INSERT INTO dbo.TargetTable OUTPUT INSERTED.ID INTO @MyVarSELECt * FROM dbo.SourceTableSELECt * FROM @MyVar