yosiasz showed this trick to convert table fields back into XML and it is also in pretty path too when I click on the field.
SELECT * FROM #TEMPTable
FOR XML PATH ('ParameterValue'), root ('ParameterValues');
When I tried to do this with JSON, it returns the correct JSON but it does not pretty path (indent). Is this possible with JSON?
SELECT * FROM #TEMPTable
FOR JSON PATH ('ParameterValue'), root ('ParameterValues');