Dear all,

Thanks for your replies, Both Cursor and "proprietary" Update statement works perfectly.:-D

Regards,

Kathir.C

The cursor It works fine on Oracle but it is for a SQL Server 2008 DB that i need it.

Please do reply anyone.