Try to add an compress to the datefield. substr(trandate,1,7) in ("2016-11","2016-10","2016-09") ---> substr(compress(trandate),1,7) in ("2016-11","2016-10","2016-09") It look like the where claues is applied on the result from odbc and not passed to sql server.
... View more