• It would probably be useful to see what the stored procedure actually does.

    Any reason you pass dates converted to strings as parameters instead of the actual dates?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP