DECLARE @RUN_PARMS TABLE ( [SVN] VARCHAR(04) ... INSERT INTO @RUN_PARMS SELECT '1362' AS SVN ... SELECT ROW_NUMBER() OVER(PARTITION BY [SVN] ORDER BY [SVN]) AS ROWID , RP.[SVN] ...
If you add this code using [SVN](in this case a static subversion number) it will add a rowid - uniquely identifying sequential number to your output.
No comments:
Post a Comment