UFN_MEMBERSHIPSALESGETEXPIRATIONDATES

create function dbo.UFN_MEMBERSHIPSALESGETEXPIRATIONDATES
(
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @CURRENTEXPIRATIONDATE datetime
)
returns @EXPIRATIONDATES table (
    MEMBERSHIPLEVELTERMID uniqueidentifier,
    EXPIRATIONDATE datetime
)
with execute as caller
as begin

    insert into @EXPIRATIONDATES
    (
        MEMBERSHIPLEVELTERMID,
        EXPIRATIONDATE
    )
    (
        select
            MEMBERSHIPLEVELTERM.ID,
            dbo.UFN_MEMBERSHIP_CALCULATEEXPIRATIONDATEBYLEVEL(MEMBERSHIPLEVEL.ID, MEMBERSHIPLEVELTERM.ID, @CURRENTEXPIRATIONDATE) as EXPIRATIONDATE
        from
            dbo.MEMBERSHIPPROGRAM
        inner join
            dbo.MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
        inner join
            dbo.MEMBERSHIPLEVELTERM on MEMBERSHIPLEVELTERM.LEVELID = MEMBERSHIPLEVEL.ID
        where
            MEMBERSHIPPROGRAM.ID = @MEMBERSHIPPROGRAMID
    );

    return;
end