The Inline EXEC refactoring will allow you to replace the evocation of a stored procedure or scalar function with the code from within it. If you highlight any stored procedure or scalar function, in a query window, and then click on the Inline EXEC menu item in the same context menu, or hit Ctrl+B,Ctrl+F, it replaces this with the inline code.