Hello All,
Having an hard time trying to make a pivot in SQL.
E.G. :
| label | value_text | value_date | id |
| Po # | 345 | NULL | 112 |
| Po # | 123456 | NULL | 120 |
| Po # | 935131 | NULL | 134 |
So I would like to have the label section as a column name and put the value_text under the appropriate column but want to keep the ID in order to make a table with my view and join it to another table on a sql request.
Is that possible ?
Regards,
Eric