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
)