根据条件更新序列号

TABLENAME A
ID CSVFileName CSVFileLineNO CSVFiled1 CSVFiled2
1 name1.CSV       1
2 name1.CSV       2
3 name1.CSV       3
4 name2.CSV      1
5 name2.CSV      2
6 name2.CSV      3

 

WITH CTE_A AS(
                 SELECT *,ROW_NUMBER() OVER(PARTITION BY CSVFileName ORDER BY SeqID ASC) AS RN
                 FROM {2} (NOLOCK)
                 WHERE CSVFileName=@CSVFileName
            )
           UPDATE CTE_A SET CSVLineNo=RN+1;