UFN_GETGIFTAIDTRANSITIONALTAXRATE_INLINE

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@TAXDATE datetime IN

Definition

Copy


            -- Note: Any changes made here should be made to UFN_GETGIFTAIDTRANSITIONALTAXRATE

            create function dbo.UFN_GETGIFTAIDTRANSITIONALTAXRATE_INLINE
            (
                @TAXDATE as datetime = null  
            )
            returns table  
            as  
            return  
            (  
                select top 1   
                    coalesce(TRANSITIONALRATE, 0) as TAXRATE  
                from dbo.GIFTAIDTAXRATE   
                where EFFECTIVEDATE <= @TAXDATE   
                order by EFFECTIVEDATE desc
            )