SQL PIVOT

Details
Kategorie: Power BI - MDX & SQL
Zugriffe: 107

Select [AKTIV], [ARBEITSGANGNR], [ARBEITSPLATZ], [AUFNR], [AUFTRAGSTATUS], [BATCHCOLLECTOR], [BOX],
     [COLLECTIONCONTAINER_MENGE], [COLLECTIONCONTAINER_TIMESTAMP], [COLLECTIONCONTAINER_X_IDENTIFIER],
     [Container_Identification], [CUSTOMERBATCHCOLLECTOR],
     [MATNR], [MEEINHEIT], [MENGE], [SetD_X_Identifier], [Status],
     [INUSE],
     [TIME_STAMP_ORG]=[TIMESTAMP],
     [TIMESTAMP] = TRY_CAST([TIMESTAMP] as datetime),
     [VORGANG]
FROM (
          SELECT *
          FROM (
               SELECT [Identifier], [Description], [Value]
               FROM [GLOBAL_Interface].[dbo].BoxD_X
               WHERE Identifier <> ''
               ) d
          PIVOT(MAX(Value)
          FOR [Description]
          IN([AKTIV], [ARBEITSGANGNR], [ARBEITSPLATZ], [AUFNR], [AUFTRAGSTATUS], [BATCHCOLLECTOR], [BOX],
               [COLLECTIONCONTAINER_MENGE], [COLLECTIONCONTAINER_TIMESTAMP], [COLLECTIONCONTAINER_X_IDENTIFIER],
               [Container_Identification], [CUSTOMERBATCHCOLLECTOR],
               [INUSE],
               [MATNR], [MEEINHEIT], [MENGE], [SetD_X_Identifier], [Status],
               [TIMESTAMP],
               [VORGANG])
               ) piv
          ) result
WHERE [TIMESTAMP] is not null and TRY_CAST([TIMESTAMP] as date) >= getDate()-90