It depends. Just changing the inline query into a stored procedure likely won't improve performance, but having the query in an stored procedure does make tuning the query easier because you do not have to change the application in order to change the query to one that performs better.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question