Hi Jeremy

Thanks for the reply

This update is called in the DTS. The DTS is run when no one is working on the system i.e at night so even if...

I am not getting any error. The query keeps on executing. After 2 hours I have to cancel the query