Database

jkirkerx wrote:

ORDER BY CASE
WHEN vendor.Delete_Flag = '1' THEN 0
WHEN proj_cost.pref_vendor <> 'Y' THEN 1
WHEN proj_cost.pref_vendor = 'Y' THEN 2

ORDER BY
   vendor.Delete_Flag desc,   -- '1' then '0'
   proj_cost.pref_vendor asc  -- 'N' then 'Y'

ORDER BY CASE 
    WHEN Proj_Job.job_type = 'FX' THEN 0
    WHEN Proj_Job.job_type = 'OP' THEN 1
    WHEN Proj_Job.job_type = 'EQ' THEN 2
END

ORDER BY CASE 
    WHEN Proj_Job.job_type = 'FX' THEN 0
    WHEN Proj_Job.job_type = 'OP' THEN 1
    ELSE 2
END

ORDER BY 
   CASE Proj_Job.job_type
      WHEN 'FX' THEN 0
      WHEN 'OP' THEN 1
      ELSE 2
   END

SELECT Column1, Column2, CASE WHEN CRITERIA1 IS TRUE THEN (SUBQUERY1) ELSE (SUBQUERY2) END As SomeData
FROM TABLE1
WHERE CRITERIA1 IS TRUE 
OR CRITERIA2 IS TRUE

CASE WHEN CRITERIA2 IS TRUE THEN (SUBQUERY2) ELSE (SUBQUERY1) END As SomeData

where
myString has_all (Pattern1, Pattern2)

Declare @Temp Table ([Id] [int])
Insert @Temp Exec agsp_UniqueDocnum 'TEST', 0
Select * from @Temp;

Dhyanga wrote:

right direction on how to resolve this issue.