Full query...

DECLARE @C varchar(4000)

SET @C = '

SELECT DISTINCT AL1.user_id_entered, AL1.reservation_id, AL1.start_date, AL1.status_code, AL1.actual_minutes, AL1.scheduled_minutes,

AL1.customer_abbr, AL2.company_name, AL2.parent_company, AL1.reservation_name, AL1.product, AL1.customer_extend, AL1.category_abbr,

AL1.reason_code, CONVERT(varchar(3),AL1.start_date,100) AS StartDateMonth, YEAR(AL1.start_date) AS StartDateYear,

CASE

WHEN MONTH(AL1.start_date) = 1 THEN ''Q1''

WHEN MONTH(AL1.start_date) = 2 THEN ''Q1''

WHEN MONTH(AL1.start_date) = 3 THEN ''Q1''

WHEN MONTH(AL1.start_date) = 4 THEN ''Q2''

WHEN MONTH(AL1.start_date) = 5 THEN ''Q2''

WHEN MONTH(AL1.start_date) = 6 THEN ''Q2''

WHEN MONTH(AL1.start_date) = 7 THEN ''Q3''

WHEN MONTH(AL1.start_date) = 8 THEN ''Q3''

WHEN MONTH(AL1.start_date) = 9 THEN ''Q3''

WHEN MONTH(AL1.start_date) = 10 THEN ''Q4''

WHEN MONTH(AL1.start_date) = 11 THEN ''Q4''

WHEN MONTH(AL1.start_date) = 12 THEN ''Q4''

END AS StartDateQuarter

FROM vbus_dss.dbo.adt_reservations AL1, dbo.company AL2

WHERE (AL1.customer_abbr=AL2.company_abbr)

AND (' + @OperParam + @Date_String + ' AND AL1.reservation_type IN('' + @ResType + '') AND AL1.status_code IN('' + @StatusCode + ''))'

EXEC (@c)