[Solved] Custom order in SQL Procedure

Question

try this:

SELECT ..., CASE WHEN LFLT.ID = 3 THEN 0 ELSE LFLT.ID END AS OrderIndex
FROM ...
ORDER BY OrderIndex

Accepted Answer

try this:

SELECT ..., CASE WHEN LFLT.ID = 3 THEN 0 ELSE LFLT.ID END AS OrderIndex
FROM ...
ORDER BY OrderIndex