USE Northwind

DECLARE @MyTable Table
(
   OrderID   int,
   CustormerID  char(5)
)

INSERT INTO @MyTable
SELECT OrderID, CustomerID
FROM Northwind.dbo.orders
WHERE OrderID BETWEEN 10240 AND 10250

SELECT * FROM @MyTable