npyata (5/2/2013)
I have included the where caluse :where log_timestamp_dt between '2010-01-01 00:00:00.000' and '2010-02-28 00:00:00.000'
order by log_idlog_timestamp_dt between '
I want to increament the log_seqno. So I am using the vr_seqno=@vr_seqno + 1 and updating the log_seqno for each row it is fetched.
Once the above update is done I want to update the other columns based the log_seqno. The update process is running very slow. I am not able to see the results when I terminate the process.
Show us. Post the DDL (CREATE TABLE statement) for the table [TESTDB].[dbo].[match_event_log], post some sample data (meaning data you make up, not real production data) as a series of INSERT INTO statements, then show us what the data in the table shold look like when your cursor process is done.
Based just on your description, I am not sure what you are doing.