quote:
These guys are right. You don't need a cursor to do the update. Also, let me suggest that you wrap the update statement in a transaction. BEGIN TRAN...COMMIT TRAN. When you are ready to run the code, use begin tran and the update statement without the commit tran. You should see how many records have been updated (you can even do a select statement first before commiting the transaction). When you are satisfied that the right number of records are effected, then run the COMMIT TRAN portion of the batch.
Thanks! Good idea on using the Transaction wrapper.
Richard D. Cushing
Sr. Consultant
SYNGERGISTIC SOFTWARE SOLUTIONS, LLC
Richard D. Cushing
Sr. Consultant
SYNGERGISTIC SOFTWARE SOLUTIONS, LLC