your select..into statement suggestion was wonderful. It started working for me.

thanks once again.

select..into is displaying the result as 'affected 14 rows' but the result table is not being generated.

any suggestion.

select..into statement is working but i am unable to find the new stored table. can you help me in this.

thank you verymuch,

but my columns are dynamic. will the select ..into statement work for me. can you suggest any other dynamic table generation process.