SET function used in where clause

zagzebski — Tue, 03 Sep 2013 19:42:59 GMT

I am trying to set a variable:

SET JANRETENSION = B201;

(I tried it will as SET JANRETENSION = 'B201' as well and it didn't work either)

But when I use it in my where clause it is not recognized.

Here is the script followed by the error message:

ProductionByDeptByCust:

Load
[Dept] as [Temp Dept],
sum([Commission]) as [Temp Commission Dept]
Resident Production
Where
ProdGLMonthOrig <= $(JANRETENSION)

and

ProdGLMonthOrig >= $(JANRETENSION)

and

Dept<>'4'

Group By [Dept]
Order by Dept ASC;

Error MESSAGE I am getting:

Field not found - <B201>

ProductionByDeptByCust:

Load

[Dept] as [Temp Dept],

sum([Commission]) as [Temp Commission Dept]

Resident Production

Where

ProdGLMonthOrig <= B201

and

ProdGLMonthOrig >= B201

and

Dept<>'4'

Group By [Dept]

Order by Dept ASC

Re: SET function used in where clause

Anonymous — Tue, 03 Sep 2013 19:52:52 GMT

You have to use it this with single quotes:

ProdGLMonthOrig <= '$(JANRETENSION)'

and

ProdGLMonthOrig >=' $(JANRETENSION)'