quote:

---

Originally posted by calladrum

Hi All

I'm using a SQL query set up by someone else which has been working well for a while but now is throwing up the following error:

Msg 137, Level 15, State 2, Line 17
Must declare the variable '@Deduction'.

The query code is:

DECLARE @Deduction AS INTEGER

DECLARE @YearWeekFrom AS INTEGER
DECLARE @YearWeekTo AS INTEGER

------------------------------------------------------------
SET @YearWeekFrom = 201105 -- Change this value!
SET @YearWeekTo = 201105 -- Change this value!
------------------------------------------------------------

SELECT Year, Week, CCode, SUM(ISNULL(NUM_Promos,0)) AS NumPromos,
SUM(ISNULL(Total_Value,0)) AS TotalValue, SUM(ISNULL(Commission_Tot,0)) AS TotalCommission
FROM Promos
WHERE Deduction_Code_Inverse_Key = @Deduction AND ((Year * 100) + Week) >= @YearWeekFrom AND ((Year * 100) + Week) <= @YearWeekTo
GROUP BY Year, Week, CCode
ORDER BY Year, Week, CCode

Any ideas about why this isn't working?

Thanks

---

quote:

---

Originally posted by calladrum

Hello again

I added in DECLARE @Deduction AS VARCHAR (32)

and now the query appears to run but no results come in (and I know there should be) and there are no error messages. Have checked that all fields do appear in the PROMOS SQL Table. Any suggestions?

---