How can I incorporate PIVOT into a SQL query that includes CROSS APPLY OPENJSON?

edit

Here is an example SQL query that demonstrates how to incorporate PIVOT into a query that includes CROSS APPLY OPENJSON:

SELECT *
FROM (
    SELECT 
        [key] AS 'Name', 
        value AS 'Value'
    FROM Table1
    CROSS APPLY OPENJSON(JSONColumn)
) AS t
PIVOT (
    MAX(Value) 
    FOR Name IN ([Name1], [Name2], [Name3])
) AS p

In this example, the query retrieves data from a table named Table1, which includes a JSON column named JSONColumn. The OPENJSON function is used to parse the JSON data and return a set of key/value pairs. The resulting dataset is then pivoted using the PIVOT function to transform the key/value pairs into columns. The PIVOT function aggregates the data using the MAX function.

The names of the columns in the resulting pivot table are specified in the IN clause of the PIVOT function. You can modify these column names to match your specific needs.