Listing 2: Inserting Rows into Orders and Copying Them to the @NewOrders Table 
Variable
DECLARE @NewOrders TABLE
(
  orderid int,
  custid varchar(5),
  orderdate datetime
);

INSERT INTO dbo.Orders(custid, orderdate)
  OUTPUT inserted.orderid, inserted.custid, inserted.orderdate
    INTO @NewOrders
  SELECT 'A' AS custid, '20030101' AS orderdate
  UNION ALL SELECT 'B', '20030101'
  UNION ALL SELECT 'A', '20040101'
  UNION ALL SELECT 'B', '20040101'
  UNION ALL SELECT 'A', '20050101'
  UNION ALL SELECT 'B', '20050101';

-- Process new orders here.
SELECT * FROM @NewOrders;