Good help me flatten below table structure, I've tried Sql STUFF and XML path with little success.
KeyAccountProductQtyKA1P1100KA1P2200KA1P3300KA1P4400to
KeyAccountProduct;Desc;QtyKA1P1;100 | P2;200 | P3;300 | P4;400Many thanks upfront
Regards
Good help me flatten below table structure, I've tried Sql STUFF and XML path with little success.
KeyAccountProductQtyKA1P1100KA1P2200KA1P3300KA1P4400to
KeyAccountProduct;Desc;QtyKA1P1;100 | P2;200 | P3;300 | P4;400Many thanks upfront
Regards
Please give a table definition, sample data and what you've already attempted. It will help us to help you!
19 People are following this question.