yeah pal, i know i dont need a cursor to get this done....but for decrementing a column value which is passed dynamically , i came to know that i should...

yeah thats why i use stored procedure....i pass a parameter value dynamically for decrement... decrement is like...for example: if my dynamic value is 90 if my select query chooses 5...

Hi,

yes, i need dynamic query because i have to pass the table name and column name values through parameters as i shown in the query....i need cursor because i need...