UFN_APPEAL_GETMEMBERSHIPDEFAULTS

            create function dbo.UFN_APPEAL_GETMEMBERSHIPDEFAULTS
            (
                @APPEALID uniqueidentifier,
                @GIFTAMOUNT money
            )
            returns @RESULT table
            (
                MEMBERSHIPPROGRAMID uniqueidentifier, 
                MEMBERSHIPPROGRAM nvarchar(100),
                MEMBERSHIPLEVELID uniqueidentifier,
                MEMBERSHIPLEVEL nvarchar(100),
                MEMBERSHIPLEVELTERMID uniqueidentifier,
                MEMBERSHIPLEVELTERM nvarchar(100)
            )
            as
            begin
                insert into @RESULT
                    select top 1
                        MP.ID,
                        MP.NAME,
                        ML.ID,
                        ML.NAME,
                        MLT.ID,
                        MLT.TERM
                    from dbo.MEMBERSHIPPROGRAM MP
                    inner join dbo.APPEAL on MP.ID = APPEAL.MEMBERSHIPPROGRAMID
                    inner join dbo.MEMBERSHIPLEVEL ML on MP.ID = ML.MEMBERSHIPPROGRAMID
                    inner join dbo.MEMBERSHIPLEVELTERM MLT on ML.ID = MLT.LEVELID
                    where APPEAL.ID = @APPEALID
                        and MLT.AMOUNT <= @GIFTAMOUNT
                    order by MLT.AMOUNT desc, ML.SEQUENCE desc;

                return;
            end