Hi Andy,

Thanx for u r tips. I did the update statistics & now both the query & stored proc take exactly same...