Yes, thanks, correct clustered indexes all around. Query plans do not indicate any missing indexes, but haven't run general missing index search for awhile: most of the many, many...

yes, have tried recompile, clearing cache, updating stats, indexes, etc. Even of first creation of procedure same problem persists. See my further explanation in reply to Gail.

thanks.

Thanks. I have attached a file with the original procedure, the procedure with dynamic SQL, and the execution plans for each. Regarding sniffing, the original procedure time reflects...

Please get rid of the login requirement, it is just so 1995. If you need to post or answer a question, sure, but just having to login every time...