How can I change the type of output - TSQL

Question

User1439346456 posted

hi experts
my sample query is:

    SELECT 
	SUM(CASE WHEN tb.[CashStatus] = 0 AND tb.[CashPayMethod] = 0  THEN tb.[CashPayPrice] ELSE 0 END) AS [TotalCashPrice],
	SUM(CASE WHEN tb.[CashStatus] = 0 AND tb.[CashPayMethod] = 10 THEN tb.[CashPayPrice] ELSE 0 END) AS [TotalPOSPrice]
	FROM	mytable tb

my result is:

TotalCashPrice | TotalPOSPrice
________________________________
41,000,000     | 12,000,000

i want to Convert to

Value          |  Name
________________________________
41,000,000     |  TotalCashPrice
12,000,000     |  TotalPOSPrice

thanks everyone.

Answer 1

User503812343 posted

You can try using PIVOT 

https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-2017

Answer 2

User1439346456 posted

AND ANOTHER WAY

SELECT (CASE WHEN tb.CashPayMethod = 0 THEN 'TotalCashPrice'
             WHEN tb.CashPayMethod = 10 THEN 'TotalPOSPrice'
        END) as name,
       SUM(tb.CashPayPrice) as value
FROM mytable tb
WHERE tb.CashStatus = 0 AND tb.CashPayMethod IN (0, 10)
GROUP BY tb.[CashPayMethod]