Thank you aaron.reese. This is more neater solution. I had resorted to using Cursors which is not advisable with big datasets.