NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Databases > Util > Functions > dbo.GetPercentage

SQL scalar function: Util.dbo.GetPercentage

CREATE FUNCTION [dbo].[GetPercentage] (@FirstValue NUMERIC(20, 4),
                                       @SecondValue NUMERIC(20, 4))
RETURNS NUMERIC(6, 2)
AS
BEGIN
    RETURN CAST(CASE
                     WHEN @SecondValue <> 0 THEN @FirstValue * 100.0 / @SecondValue
                     ELSE 0
                END AS NUMERIC(6,2))
END

Description for SQL scalar function: Util.dbo.GetPercentage

Todo