Vitaly

### Description The SQL query returns correct results on the first run. However, on subsequent runs, an error occurs, leading to unsuccessful query execution. The error is related to the...

PIVOT does not work with subqueries or CTEs: "Column 'column_name' cannot be resolved" error

1

### Description I encountered an issue when using the PIVOT operator together with subqueries or CTEs. The PIVOT operation only works directly on a table, but not when the same...