SELECT COUNT(*) FROM myTableI have no way of knowing ahead of time which fields will participate in the query. Frequently I have to OMIT other tables' values:
WHERE Field1 IN ( ('A','B','C','F','Y')
AND Field2 IN ('1','2','3')
AND SUBSTRING(Field5,1,1) = '1' )
OR (Field3 IN ('X','Y','Z') and State = 'NY')
OR Field4 = 'ABCDEFG'
SELECT ...The way I approach this (for lack of a better solution) is:
WHERE ...
AND NOT Email IN (SELECT Email FROM #tmp1)
AND Zip IN (SELECT Zip FROM #tmp2)
SET @lcSQLCmd = 'SELECT COUNT(*)
FROM mytable
WHERE ' + @lcQueryString
EXEC(@lcQuery)