• Starting and ending dates seem to be an issue for many people. Are the database fields datetime data types? Then check if the code is considering the time portion of the data.

    For example, starting 01/01/2015 and ending on 01/31/2015

    Parameters passed from SSRS are interpreted as midnight. Unless the code considers that, the data from 01/31 is left off.

    As for caching questions, take a look at this article.

    https://msdn.microsoft.com/en-us/library/ms155927.aspx

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/