http://www.c-sharpcorner.com/UploadFile/rohatash/calling-a-function-from-a-stored-procedure-in-sql-server-201/This is best example

Create PROCEDURE [dbo].[YourProceduteToCallFunction] ( @YourParameter int, ) AS BEGINSelect dbo.[YourFunctionName](@YourParameter ) END

Select yourfunctionName And keep this query in stored procedure.