Actual Practice : Scalar Valued Functions in my work - 2

1. Scalar Valued Functions
   Let us direct to acutal instance:

USE [*****]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[aaa_GetExcessiveFobearance_HDM]
(
    @LoanNo As varchar(10),
    @CapitalizedDebt DECIMAL(14,2), 
    @PropertyValue DECIMAL(14,2),
    @MaximumForbearance DECIMAL(14,2),
    @MaximumForgiveness DECIMAL(14,2)
)
RETURNS 
     BIT
AS
BEGIN
    .......
    SELECT @ForbearanceLimit =  [dbo].GetInvestorForbearanceLimit](@LoanNo,@CapitalizedDebt,@PropertyValue)
    .......
    RETURN  @ExcessiveFBFlag
END

Yes, we need take a look at the “Returns : BIT” which is the type of “Return : @ExcessiveFBFlag”.
This value can be got using below sql:

select dbo.aaa_GetExcessiveFobearance_HDM
(
    '0014585897', 35940.99,70000,0,1569.35
) as ExcessiveFBFlag

You can notice the structure of this function that you can know how to use this Scalar Valued Function.

When you need the value of it in some other requirement, you just can use it as a column in the specific sql statement.