rows to column sql

Question

Hi Expert,

I wanted tp convert columns into rows using the conversation table. How i can do it

here is my source:

Conversation table

Expected output

needs to convert this using case statement or any other method and column in rows in azure

Answer 1

This should work:

;WITH cte AS  
    (SELECT 'Cycle' AS Property  
            Cycle AS Value  
     FROM SourceTable  
     UNION ALL  
     SELECT 'Car' AS Property  
            Car AS Value  
     FROM SourceTable)  
SELECT *  
FROM cte  
     INNER JOIN  
     ConversionTable AS T  
         ON cte.Value >= T.Min  
            AND cte.Value < T.Max