I can never remember this syntax correctly. Now maybe I will.
, ROW_NUMBER() OVER (PARTITION BY [VENDNO] + '-' + [PARTNO] ORDER BY [LoadDateTime] DESC) AS [Row#]
I can never remember this syntax correctly. Now maybe I will.
, ROW_NUMBER() OVER (PARTITION BY [VENDNO] + '-' + [PARTNO] ORDER BY [LoadDateTime] DESC) AS [Row#]