I have written a query that when executed directly from the query analyser takes about 15 seconds to execute. When I make a stored procedure out of this query it takes several minutes to get the same results. When I look at the execution plans of both version the big difference is that the query uses...