Thank you very much will check and update you by end of the day.

hi opc.three,

Sorry for the delay in sending message.

yes you are correct they both resides in the same database and simple proc which holds all the transactions will be fine. but...

Hi opc.three,

Thanks for your reply. Do you have any sample peice of code which shows how to use object inorder to acheive this task.

my taks is I will get 10...

Thanks for your prompt reply.

You are correct spt_key in temptable is a uniqueidentifier column. Since there is no datatype as guid during variable creation I picked string. I want...