• I want to increment vr_seqno by 1. this query will increment vr_seqno?

    Update [CAMINO].[dbo].[match_event_log]

    set log_seqno = vr_seqno

    FROM (select

    row_number() over (order by log_id,log_timestamp_dt) AS vr_seqno,

    log_id

    from [TESTDB].[dbo].[match_event_log]

    where log_timestamp_dt between '2010-01-01 00:00:00.000' and '2010-02-28 00:00:00.000'

    ) MyData