07-31-2023, 08:14 AM
I have a table like this...
CustomerID |DBColumnName |Data
-------------|---------------|----------
1 |FirstName |Joe
1 |MiddleName |S
1 |LastName |Smith
1 |Date |12/12/2009
2 |FirstName |Sam
2 |MiddleName |S
2 |LastName |Freddrick
2 |Date |1/12/2009
3 |FirstName |Jaime
3 |MiddleName |S
3 |LastName |Carol
3 |Date |12/1/2009
And I want this...
Is this possible using PIVOT?
CustomerID |FirstName |MiddleName |LastName |Date
------------|------------|--------------------|----------------|-------
1 |Joe | S |Smith |12/12/2009
2 |Sam | S |Freddrick |1/12/2009
3 |Jaime | S |Carol |12/1/2009
CustomerID |DBColumnName |Data
-------------|---------------|----------
1 |FirstName |Joe
1 |MiddleName |S
1 |LastName |Smith
1 |Date |12/12/2009
2 |FirstName |Sam
2 |MiddleName |S
2 |LastName |Freddrick
2 |Date |1/12/2009
3 |FirstName |Jaime
3 |MiddleName |S
3 |LastName |Carol
3 |Date |12/1/2009
And I want this...
Is this possible using PIVOT?
CustomerID |FirstName |MiddleName |LastName |Date
------------|------------|--------------------|----------------|-------
1 |Joe | S |Smith |12/12/2009
2 |Sam | S |Freddrick |1/12/2009
3 |Jaime | S |Carol |12/1/2009