Pivoting the Settings table in PDM's database

[jmlhunt]

Hello,
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?

[jmlhunt]

I found a solution. Is there a better way?

[jmlhunt]

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