GilaMontser - so the way I have it is the most efficient - it takes hours to run so I was hoping it could be improved.

I am getting an error on near join

Msg 156, Level 15, State 1, Line 6

Incorrect syntax near the keyword 'join'.

Msg 102, Level 15, State 1, Line 14

Incorrect syntax near 'AB'.

OK - thats it

@Yearmonth is 201202 (for Feb 2012) and -93 gives 201109 (for Sept 2011)

Perfect thanks for your help - I am no longer going around in circles

All assumptions are correct - is the -93 subtracting 93 days ?

Hi

It is in this piece (this one is -94 and >=190000

WHERE (RTRIM(YEAR(A.DOCDATE)) + RIGHT('0' + CONVERT(VARCHAR, MONTH(A.DOCDATE)), 2) <= (CASE WHEN SUBSTRING(@YEARMONTH, 5, 2) IN ('01',...

WHERE (RTRIM(YEAR(A.DOCDATE)) + RIGHT('0' + CONVERT(VARCHAR, MONTH(A.DOCDATE)), 2) <= @YEARMONTH) AND

...

This worked

=IIF(LTRIM(RTRIM(Fields!USERDEF1.Value)) = "CARA","DodgerBlue","Black")