Jack Corbett (5/2/2014)
Parameter sniffing won't cause the results returned to be incorrect it can cause a sub-optimal plan to be used skewing performance. If parameter sniffing causes incorrect results that's a bug and a very big one that I think would have been caught and fixed a long time ago.
Jack, I only said since the data is not retrieved correctly may be check that aspect too.. I didn't mean that's the only root cause.
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.