CREATE TABLE #morth(a char(1), b char(1));
INSERT #morth(a,b) VALUES('x','y'),('p','q');
CREATE TABLE #floob(id int IDENTITY(1,1), a char(1), b char(2));
INSERT #floob (a,b)
OUTPUT inserted.id, inserted.a, inserted.b
SELECT a,b FROM #morth;
GO
DROP TABLE #floob, #morth;