SQL Pivot table?

Question

Hi I am looking for a SQL Script the can pivot the following table

Every values in ObjectClassProperty column must become columns. ObjectInstanceProperty will become values for the respectivly newly created column.

One thing to keep in mind. ObjectClass is dynamically changing.

Does this answer your question? [Convert Rows to columns using 'Pivot' in SQL Server](https://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server) — Dainius Lukša, May 06 '22 at 11:01

score 0 · Answer 1 · answered May 06 '22 at 12:03

0

I have implemented once such similar solution in MS SQL Server 2019 version. Details can be found in the dbfiddle<>example<>dynamicpivot.

Note: This will work if there are not duplicates in ObjectClassProperty.

answered May 06 '22 at 12:03

1 Answers1