Breaking News: Grepper is joining You.com. Read the official announcement!

sql server function to calculate a percentage

Add Answer

Fortune Mbulazi answered on June 4, 2021 Popularity 9/10 Helpfulness 2/10

answer sql server function to calculate a percentage

related sql percentage

related calculate percentage in sql

sql server function to calculate a percentage

Comment

-- =============================================
-- Author:		Simphiwe Mabaso
-- Create date: 05 July 2022
-- Description:	When called this function returns a percentage
-- =============================================
ALTER   FUNCTION [dbo].[CalculatePercentage]
(
	@Value DECIMAL(18, 2),
	@Total DECIMAL(18, 2)
)
RETURNS INT
AS
BEGIN
	-- Declare the return variable here
	DECLARE @Percentage AS DECIMAL(18, 2);

	-- Add the T-SQL statements to compute the return value here
	SET @Percentage = @Value / @Total * 100;

	-- Return the result of the function
	RETURN @Percentage;
END

------------------------------------------------------
--Testing the function
DECLARE @Percent DECIMAL(18, 7),
		@PercentageInString NVARCHAR(50);

SET @Percent = dbo.CalculatePercentage(92, 45);

SET @PercentageInString = CONVERT(NVARCHAR(50), @Percent) + '%';

SELECT @PercentageInString  [Percentage];

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: function percentage sql sql-server

Link to this answer
Share Copy Link

Contributed on Jul 06 2022

Fortune Mbulazi

0 Answers Avg Quality 2/10

Closely Related Answers

sql percentage

Comment

SELECT CONCAT(ROUND(smallerNum*100/biggerNum, 2), '%') FROM table

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: percentage p

Link to this answer
Share Copy Link

Contributed on Dec 20 2021

Muddy Macaque

0 Answers Avg Quality 2/10

calculate percentage in sql

Comment

SELECT SUM(MARKS)*100/COUNT(MARKS) FROM STUDENT_MARKS

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: percentage p

Link to this answer
Share Copy Link

Contributed on Jun 04 2021

Hacker Harsha

0 Answers Avg Quality 2/10

sql server function to calculate a percentage

Contents

More Related Answers

sql server function to calculate a percentage

Closely Related Answers

sql percentage

calculate percentage in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.