GetPersentFunction

USE [oktell]
GO
/****** Object:  UserDefinedFunction [dbo].[GetTimeFromSecond]    Script Date: 05.08.2019 9:12:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[GetPersent] (@param1 int, @param2 int)
RETURNS varchar(10) AS
BEGIN
    RETURN IIF
        (
            @param2 != 0 AND @param2 IS NOT NULL
            , CAST(ROUND(CAST(@param1 as float) / @param2, 4) * 100 as nvarchar(10)) + '%'
            , '0%'
        )
END