help us help you...when i read your question, i think the question is "when i profile my procedure, it never finishes. when i just run it, it is fast"
is that correct?
or is this a question about SOMETIMES your procedure is slow, and sometimes it is fast(parameter sniffing?)
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!