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.

The only problem I am having is creating a temp table without a select into statement.

How would I create and empty temporary table.

He will not allow the use of a cursor.

I like it here.

Help


Thanks
Jim