Difference in terms of speed for SP and Query text.

Hi Visakh,

Actually I cannot modify the stored procedure that's why i copy the query inside and then i modify based on the requirement given by user instead of replicating the query again. By the way, I dont have any access or permission to modify the proc. I'll try to check the execution plan. thanks.