Just a quick post to cover somthing that I've seen cropping up a lot recently. Thats copying the results of a stored procedure in to a table.
The code below will call the stored procedure spGetRecords and copy its results into
the specified table.
CREATE TABLE #tmpBus ( COL1 INT, COL2 INT ) INSERT INTO #tmpBus Exec SpGetRecords 'Params'