SELECT CategoryName FROM Category WHERE CatId IN (55,568,5412,8991,928,3213,142,9250,12330,2983)
select * from ProductGroups where GroupID in (24,12,7,14,65) order by case GroupId when 7 then 1 -- First in ordering when 14 then 2 -- Second else 3 end
SELECT CategoryName FROM Category JOIN ( SELECT 55 AS CatId UNION SELECT 568 UNION SELECT 5412 UNION SELECT 8991 UNION SELECT 928 UNION SELECT 3213 UNION SELECT 142 UNION SELECT 9250 UNION SELECT 12330 UNION SELECT 2983 ) AS CatFilter ON CatFilter.CatId = Category.CatId ORDER BY CatFilter.CatId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)