
T-SQL equivalent of Excel “MAX” function to return larger of two numbers
By: a guest on Jan 28th, 2012 | syntax:
None | size: 0.41 KB | hits: 23 | expires: Never
CREATE FUNCTION dbo.LargerOf
(
-- Add the parameters for the function here
@First FLOAT,
@Second FLOAT
)
RETURNS FLOAT
AS
BEGIN
DECLARE @Result FLOAT
IF @First > @Second
SET @result = @First
ELSE
SET @Result = @Second
RETURN @Result
END
GO
set @max = case when @first > @second then @first else @second end
CASE
WHEN @First >= @Second THEN @FIRST
ELSE @Second
END