Dynamically Uncollapse Columns for Tabular Output
I'm trying to create a stored procedure like in the link below and while its not erroring out, its also not uncollapsing columns like it says it would. I'm not great at SQL and I've tried this in ETL but I can't get it to work there either.
What I'm trying to do is to take a dataset that looks like this and have 2 different types of cards (a multi-line chart with the EBProjectHealth as the series and a table that looks like what's below)
One row for each ProjectName
Count of Distinct ProjectName for each month, by EBProjectHealth (as scope)
When I run the stored procedure, it gives me an output that looks like the original input above with back ticks surrounding the date field. I also tried it on the ProjectName field with the same result.