Pivoting the Settings table in PDM's database

I have a situation where I need to pivot PDM’s Settings database table. I know how to do this with the variableName and variablevalue, but have never tried it with the Settings table. I know the example below is incorrect. What is the right way to do it?

I found a solution. Is there a better way?

using the With cause is the solution I was needed, not the Pivot operator

1 Like