Forum Discussion

CHEST400's avatar
CHEST400
Copper Contributor
Apr 05, 2022

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.

  • olafhelper's avatar
    olafhelper
    Bronze 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

Resources