Hello I have a stored procedure that at the end of it, produces a pivot output by month_quantity
The 12 months are static and I would like to learn if it is possible to, using the data, and code I have, to make the column names dynamic instead that always returning twelve.
I will use this code to later feed a SSRS report, that is if the column month names can be created dynamically.
Any information and/ or examples would be really appreciated.
Thank you very much.
I attached some data and the code that produces the prepivot table and the output pivoted data set