Printing Column in SQL

Question

Dear I have a table called Dummy On that column are Dm_Ex Dm_SL Dm_Ad all data type numeric. What I want if Dm_Ex>0 then ‘Ex’ if Dm_SL>0 then ‘SL’ if Dm_Ad>0 then ‘AD’ Dm_Ex Dm_SL Dm_Ad Result Want 1 0 1 EXAD 1 1 1 EXSLAD 0 1 1 SLAD 1 0 0 EX I used case but not success. CASE WHEN Dm_Ex > 0 THEN 'EX' WHEN Dm_SL > 0 THEN 'SL' WHEN Dm_Ad > 0 THEN 'AD' ELSE 'N/A' END Thanks Basit.

Sabyasachi Mishra · Answer

basit khan Let me know whether the provided query works for you or not? Hope that helps . Accept all the answer that helps you.

Sabyasachi Mishra · Answer

Try this WITH CTE AS ( SELECT * CASE WHEN Dm_Ex > 0 THEN ' EX ' ELSE '' END + CASE WHEN Dm_SL > 0 THEN ' SL ' ELSE '' END + CASE WHEN Dm_Ad > 0 THEN ' AD ' ELSE '' END AS Result FROM Employee ) SELECT Dm_Ex  Dm_SL  Dm_Ad  substring( Result  1 len(nullif( Result '')) - 1) AS Result FROM CTE Hope that helps . Accept all the answer that helps you.