Hi:
Basically I don't know of any other way to this without using cursor. I have to take 2 values from a single record from the outer cursor and pass it to the other stored proc which will give me a recordset that can have more that 1 records and I need to update each of those records. This is a nightly process.

Could you explain how I can use temp tables for this kind of operation ?

Thanks