UFN_RECOGNITIONLEVEL_GETAMOUNTBYDATE

Returns the minimum amount of a recognition level for a given date.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONLEVELID	uniqueidentifier	IN
@DATE	datetime	IN

Definition

Copy



        create function dbo.UFN_RECOGNITIONLEVEL_GETAMOUNTBYDATE
        (
              @RECOGNITIONLEVELID uniqueidentifier, 
              @DATE datetime
        )
        returns money
        with execute as caller
        as begin
            declare @AMOUNT money;

            select top 1 @AMOUNT = AMOUNT
            from dbo.RECOGNITIONLEVELAMOUNT
            where RECOGNITIONLEVELID = @RECOGNITIONLEVELID 
                and coalesce(ACTIVEDATE, 0) <= @DATE
            order by ACTIVEDATE desc;

            return @AMOUNT 
        end