UFN_MEMBERSHIPLEVELTERM_GETTERMINFO

create function dbo.UFN_MEMBERSHIPLEVELTERM_GETTERMINFO
(
    @MEMBERSHIPPROGRAMID uniqueidentifier
)
returns @LEVELTERMS table (
    MEMBERSHIPLEVELTERMID uniqueidentifier,
    TERMTIMELENGTH int,
    TERMLENGTHCODE int
)
with execute as caller
as begin

    insert into @LEVELTERMS
    (
        MEMBERSHIPLEVELTERMID,
        TERMTIMELENGTH,
        TERMLENGTHCODE
    )
    (
        select
            MEMBERSHIPLEVELTERM.ID as MEMBERSHIPLEVELTERMID,
            MEMBERSHIPLEVELTERM.TERMTIMELENGTH as TERMTIMELENGTH,
            MEMBERSHIPLEVELTERM.TERMLENGTHCODE as TERMLENGTHCODE
        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