• Could that query form part of a stored procedure that has a RECOMPILE hint either for the whole proc, or just that statement itself?



    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne