Forum Discussion
CHEST400
Apr 05, 2022Copper Contributor
SQL Pivot Table
I have a query which returns mulitple rows per job.
I would like all the fields to show as one row,
The first image shows the rows for a single job, some data is the same on each row but other columns they are different. I would likeone row with the grouped data then a column for each row of different data there is. I.e the plannedenddate, workcenter,then each department which is already coverted using a pivot table.
- olafhelperBronze Contributor
The first image shows the rows for a single job
CHEST400 , and what should we do with such a microscope small screenshot; we can't query images?
Please post table design as DDL, some sample data as DML statement and the expected result.
Olaf