Thanks for the answers.

I just can't understabd why it's not possible to store multiple columns returning from a dynamic Select statement which is executet with EXECUTE into a temporary table.

If I'm gonna use the LOOP through the SELECT statement, how can insert the data from the record into the temp table?

Janek Sendrowski