row_nums AS ( SELECT DATE, DESC, NUM, ROW_NUMBER() OVER (PARTITION BY DATE, DESC ORDER BY NUM ASC) AS Row_Num FROM ****** ) SELECT .................
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)