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
)