the data is 1:1 with SF on the sql server with same named columns, yet...
SELECT ID,TIER__C FROM [salesforce_stage].[dbo].[SFDC_ACCOUNT] where TIER__C NOT IN ('C1', 'E1', 'E2', 'E3', 'E4', 'WHOLESALE')
gives me 850 rows of results vs:
SELECT ID, TIER__C FROM ACCOUNT WHERE TIER__C NOT IN ('C1', 'E1', 'E2', 'E3', 'E4', 'WHOLESALE')
309361 results on salesforce.
I'm not sure why there is such a huge discrepancy. Is there something related to soql syntax with IN that is drastically different from sql server?