CREATE FUNCTION YourFunction_Name() RETURNS Decimal(6, 2) // Set your return type AS BEGIN // your calculation here. RETURN 944.22 // return your value END; GO
http://www.dotnetfunda.com/codes/code3295-how-to-create-function-in-sql-2008.aspx
Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com
Login to post response