USP_DATALIST_DAILYSALEITEMMEMBERSHIP

            create procedure dbo.USP_DATALIST_DAILYSALEITEMMEMBERSHIP
            as
                set nocount on;

                -- Memberships

                select DSI.ID,
                       DSI.TYPECODE,
                       DSI.TYPE,
                       dbo.UFN_DAILYSALEITEM_BUILDMEMBERSHIPBUTTONTEXT(DSI.ID) BUTTONTEXT,
                       MP.NAME MEMBERSHIPPROGRAM,
                       ML.NAME MEMBERSHIPLEVEL,
                       MLT.TERM MEMBERSHIPLEVELTERM,
                       coalesce(MLTC.DESCRIPTION,'') MEMBERSHIPLEVELTYPE,
                       DSI.ISACTIVE
                from dbo.DAILYSALEITEM DSI
                inner join dbo.DAILYSALEITEMMEMBERSHIP DSIM on DSI.ID = DSIM.ID
                inner join dbo.MEMBERSHIPPROGRAM MP on MP.ID = DSIM.MEMBERSHIPPROGRAMID
                inner join dbo.MEMBERSHIPLEVEL ML on ML.ID = DSIM.MEMBERSHIPLEVELID
                inner join dbo.MEMBERSHIPLEVELTERM MLT on MLT.ID = DSIM.MEMBERSHIPLEVELTERMID
                left outer join dbo.MEMBERSHIPLEVELTYPECODE MLTC on MLTC.ID = DSIM.MEMBERSHIPLEVELTYPECODEID
                where DSI.TYPECODE = 2