How to keep a specific row as the first result of a query (T-SQL)?
One way;
SELECT Name FROM ( SELECT 'All' as Name UNION SELECT DISTINCT Manager FROM IS_Projects) TORDER BY CASE Name WHEN 'All' THEN 0 ELSE 1 END, Name
This is one way:
SELECT ManagerFROM (SELECT 'All' Manager, 1 Order UNION ALL SELECT DISTINCT Manager, 2 Order FROM IS_Projects) AORDER BY Order, Manager