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;
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;