Hi Lowel,

Thanks for ur quick response ..can i do that in master database because i'm a tester i don't know ..can i do that or not..

Here is my database details..can you answer accordingly..

My db name:Max_Test

My table name: #temp.

I need these columns from that table are offer_id,reservation_num,personal_id,acct_nbr_he.

PLs reply TIA.