just a thought and maybe provide flexibility if you require....
IF OBJECT_ID('tempdb..sort') IS NOT NULL DROP TABLE sort;
CREATE TABLE #sort
(sortID int not null,
sortvalue int not null);
INSERT #sort VALUES (1, 2323),(2, 1236),(3, 5623);
SELECT c.empid
FROM consumer AS c
INNER JOIN #sort AS s
ON c.empid = s.sortvalue
ORDER BY s.sortID
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day