Joined: 23 Jul 2008 Posts: 29 Location: Little Rock - Arkansas
My requirement is that, in the update query based on the key fields for group number and division number on the table which are read from the input file, all the records are updated using a update query, but i want to write a report on all the records that are updated when the update is successful. Since the query at a time picks up all the records satisfying the condition and updates them at a time, for every input record only once the update query is executed. Please let me know how to write a report on all the updated records.
Note :- Using cursor we can write it by declaring a cursor, fetch n for each n every successful fetch we can update n write a report, but do let me know any other options where there could be minimal changes in the code.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
let me know any other options where there could be minimal changes in the code
I'd suggest the priorities be adjusted.
The code needs to meet the business requirement, work correctly every execution, be easily maintainable, and not consume a reasonable amount of system resources.
If this takes 20 or 70 lines of code is not the issue. Something done with only the goal of "minimal changes" will usually not be well done and the cost of supporting/running it outweighs the cheapness of the delivery.