dthansen
asked on
Horizontal SQL Query
I have a table with the following rows and I need to produce a view that returns 1 row per customer with the 'TaxDetail' values comma-separated.
Example Values:
CustomerID, | TaxDetailID (this is the column header)
1 | 01
1 | 02
1 | 03
2 | 01
2 | 02
I need a query that would return the 2 rows below,
1 | 01, 02, 03
2 | 01, 02
Any advice is appreciated.
Dean
Example Values:
CustomerID, | TaxDetailID (this is the column header)
1 | 01
1 | 02
1 | 03
2 | 01
2 | 02
I need a query that would return the 2 rows below,
1 | 01, 02, 03
2 | 01, 02
Any advice is appreciated.
Dean
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.