thanks for your quick response. really appreciate that.

This will solve it but urpose is not achieved. i am using a cursor to fetch records with combination of primary keys and want to change the date to start off from 2013-05-301 . means

table is having 57000 records.

it will pick first row based on pk and changed its date from 2013-05-31 it is to 2013-05-30 then next row

changing it from 2013-05-30 to 2013-05-329 and so on till it finished all resulting in all unique columns.

hope you understand the situation 🙁