Showing posts with label SQL multiple rows to single row. Show all posts
Showing posts with label SQL multiple rows to single row. Show all posts

Tuesday, August 29, 2017

SQL: Pivot multiple rows into a single row for a Primary Key using XML_PATH.

Sample Data:


Desired Output Format:


at No comments:
Labels:
Subscribe to: Comments (Atom)

Informatica Expression Code: Chr(10): Line Feed character  Chr(13): Carriage Return character.  Chr(12): Form Feed Expression Code to...