sql - MSSQL : Transpose-Pivot table without aggregate function

Question

I need some help about MS SQL Transpose. I tried many pivot codes but they didn't help on my data. This is my data. enter image description here

我想在没有聚合的情况下转置(旋转)它。数据应该是这样的，

enter image description here

我尝试了下面的代码；

SELECT * 
FROM (
        SELECT
        dm
        ,max(hucre) as mxhucre
        FROM #dene
        group by dm 
        ) as pTablom
PIVOT
(
        max(mxhucre)
        FOR dm IN (
        [1000_TEKİRDAĞ TM]
        ,[10000_TEKIRDAG OB1]
        ,[10100_YAĞCI DM]
))AS Pvt

但是它得到了，

enter image description here

这不是我想要的数据。大多数值都消失了

如果我不使用聚合(max-min.. 等)，代码将不起作用。

请帮忙

Answer 1

使用条件聚合

SELECT 
    max(case when dm='1000_TEKİRDAĞ TM' then hucre end) as '1000_TEKİRDAĞ TM'
    max(case when dm='10000_TEKIRDAG OB1'then hucre end) as '10000_TEKIRDAG OB1',
    max(case when dm='10100_YAĞCI DM  H04_T10' then hucre end) as '10100_YAĞCI DM  H04_T10'
FROM #dene
group by dm