>Hi Dragan
>
>>It is possible, but you better roll up your sleeves.
>
>Thanks for your detailed way of doing the same. I very much agree with you that it is quite some work but I guess what has to be done has to be done.
>
>Thanks a lot.

inaddition to what dragan said u can also make the temp table updatable through spt and then update it at once rather than sending individual insert commands to the sql server