SELECT SUM(...), ... FROM (SELECT TOP(10) CASE WHEN ROW_NUMBER() OVER (...) = 1 THEN 'Set 1' ELSE 'Set 2' END AS SetID, ... FROM ... ORDER BY ...) A GROUP BY A.SetID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)