Hi,
I have looked into pivot but I think it requires an aggregate function which I do not need (I think).
The result of my query is this
Name Property Name PropertyValue
---------- ---------- ----------
lorem Work Phone 000.111.2020
ipsum Email
[email protected]
To
Name Work Phone Email
---------- ---------- ----------
lorem 000.111.2020
[email protected]
ipsum 001.101.2010
[email protected]
I don't think I should use pivot here because I don't need to aggregate anything, I just want the row data to become a column.