UFN_GETGIFTAIDBASETAXRATE_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_GETGIFTAIDBASETAXRATE

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