Forum Discussion
Abdel1978
Nov 13, 2023Copper Contributor
Pivot and group table.
Hello Evevryone, I have table Zipo with the following colomns: RdvId int, WorkLineNumber int , WorkDescription nvarchar(250): Example of data RdvId WorkLineNumber WorkDescription 1177 0 ...
Abdel1978
Nov 13, 2023Copper Contributor
SELECT RdvId
,MAX(CASE WHEN WorkLineNumber = 0 THEN WorkDescription END) AS Q1
,MAX(CASE WHEN WorkLineNumber = 1 THEN WorkDescription END) AS Q2
,MAX(CASE WHEN WorkLineNumber = 2 THEN WorkDescription END) AS Q3 F
ROM #t
ROUP BY RdvId;