-- Temp table CREATE TABLE #temp01 ( pk int Identity(1,1), col1 char(20)) -- Table variabble DECLARE @table_variable TABLE ( pk int Identity(1,1), col1 char(20)) INSERT INTO @table_variable (col1) VALUES( 'Some text') SELECT * FROM @table_variable>The boss wants me to create a temporary table and then do a while loop and feed data into the temporary table row by row.