there is some calculation in the store proc which i can't do it on my select statement, and i ve got all the values of parameter through the select statement.

i am...

Thanks Phil, query run time in QA got reduced to 2.5 min from 14min

thanks phil

yes it got time out by doing order by in EM, do you know how can i speed up the query response.

thanks for your reply