Editted my response after rereading.

Edit: Misunderstood, sorry.  Can your incomes have a value lower than 0? For example, couldyou instead do:
=CountDistinct(IIf(IIf(IsNothing(Fields!Income.Value), -1, Fields!Income.Value) = 0, Fields!ClientID.Value, Nothing))

Thanks Perry, but I think you've missed the point of post. The remote server is not on site, nor online. I cannot sync to something, if that something isn't accessible.

Maybe:
="FROM " & FORMAT(DATEADD("M", 0 - Parameters!MONTHS.Value, DATEADD("M", DATEDIFF("M", "01/01/2000", TODAY()), "01/01/2000")), "MM/dd/yyyy hh:00 tt")
Note this will always round to the start of the month, at midnight. So,...

Thanks John.

The server will be rebuilt exactly as it is now. Same SQL version (down the the KB), same Windows version, should even be the same hardware. Instance...

On the note of "gotchas", as Gail pointed out there are a lot of changes from 2000 to 2016. MSDN does list all the Breaking changes from version to version,...

SELECT CONVERT(decimal(8,4),REPLACE(@B, '%','')) / 100;
--Or, if you want ANSI SQL
SELECT CAST(REPLACE(@B, '%','') AS decimal(8,4)) / 100;

Edit: Best practice, store your Percentage values as decimals,...

Grouping does exactly that, groups the data. Thus, in your SQL above it will given you the maximum date for each individual group you have defined ( l.sys_loc_code,...

I, too, have no idea what you mean. If, however, you have additional requirements, then do please let us know(with some context). I'm sureone of us will be able to...

If you want to get the value '80' from 'APP4005673452-45580' why not use RIGHT('APP4005673452-45580', 2)?

There's no DDL or sample there, so the above won't help us help you. Check the link in my signature.

Can you provide us with some DDL and (obscured) sample data please? We have little idea from your post what your structure looks like so giving an answer for your...

New...