Listing 3: Explicit CAST Call That Manages Datatypes at Multiple Steps Within Calculation
DECLARE @v1 DECIMAL(19, 9), @v2 DECIMAL(19, 9), @v3 DECIMAL(19, 9)
SET @v1 = 7.85
SET @v2 = 455
SET @v3 = .000001

SELECT CAST(CAST(@v1 * @v2 AS DECIMAL(19, 9)) * @v3 AS DECIMAL(19, 9))