 -- DROP and CREATE PROCEDURE

-- DROP PROCEDURE CalcVars

 -- DECIMAL(10, 4) is 10 places to the right and left of the decimal point
 -- the 4 is the number of decimals returned to the right of the decimal point
 -- 10 - 4 = 6	6 is the number of places which can be stored to the left of the decimal point
 -- 6 to the left and 4 to the right total 10

--CREATE PROCEDURE CalcVars @VarOne DECIMAL(10, 6), @VarTwo DECIMAL(10, 6)
--AS
--DECLARE @VarResult DECIMAL(10, 6)
--SELECT @Varresult = @varOne * @varTwo
--PRINT @VarResult
--RETURN @VarResult

--EXEC CalcVars 841.0147127, 11.8882154

--EXEC CalcVars 842.0147127, 11.8882154

