I am creating a SSRS report with sql 2005 and VS 2005. I have created a select that is 1200 + lines so it will not fit directly into SSRS so I am converting the SELECT into a stored procedure.
I keep getting an error when I try to unpivot the data
Here is the error:
Msg 102, Level 15, State 1, Procedure usp_rpt_315_service_level_to_customer, Line 509
Incorrect syntax near 'Picked within 7 days of planned start date'.
and here is the unpivot statement:
Total FOR KPI IN ("Picked within 7 days of planned start date", "Picked after 7 days of planned start date", "Never Picked (Greater than $$)", "Never Picked (Less than $$)")
) AS Tot
Of course there is the rest of the select above this but it is to large to go through here. The select does work as a select, I hope it is someting such as the double quotes in the unpiviot (which i tried with single quotes).
Anyway is it p
View Complete Post