Row_Number1 | Row_Number2 | GroupJobID | JobID ---------------------------------------------- 1 | 1 | 6200 | A001 1 | 2 | 6200 | A002 2 | 1 | 6202 | A003 2 | 2 | 6202 | A004 2 | 3 | 6202 | A005 3 | 1 | 6201 | A006 3 | 2 | 6201 | A007 3 | 3 | 6201 | A008 3 | 4 | 6201 | A009 4 | 1 | 6202 | A010 5 | 1 | 6201 | A011
Row_Number1
JobGroupID
SELECT ROW_NUMBER() OVER (PARTITION BY JobGroupID ORDER BY JobGroupID) As RowNumber2, JobGroupID, JobID FROM ABC ORDER BY ABC.Orders ASC
SELECT RowNumber1, GroupJobID, JobID, ROW_NUMBER() OVER(PARTITION BY RowNumber1, GroupJobID ORDER BY JobID) RowNumber2 FROM Jobs
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)