Then, may be problem with data

have u updated with my procedure.....(missing columns included in insert for trans table)

do one thing....

post rate value which u get from another table in the first statement... that row data and

post the row of data which u r trying to update in trans table if data exists

i guess.. this problem with the data