fetch results of a cursor to a temporary DB for manipulation

Hi all

I want to put the fetch results of a cursor to a temporary DB for manipulation, Im selecting all columns from the table in the cursor and the number of total columns is unknow.

Please guide me on how this could be done...

Thanks in advance

Regards

BennyGet rid of the cursor and use a select into statement with the same query to create a table in the temp database.

If you want to perform row by row oprerations on the resultset use the identity function to create an identity on it then you can loop through that without need for a cursor.