Ray M,

Thanks for the quick response...

I don't know the column type to declare the table variable initially.

I have to query sysColumns table to know the columns and then I have to create a temp table based on the result.

Regards,