Thanks for your help. I used a cursor instead and it works a treat.

Thanks.

AS per BOL documentation (Look for Update described in BOL), the update query where in the...