UFN_DISCOUNTAVAILABILITY_MEMBERSLEVELSLIST

This function returns discount availability members\levels as a list given its ID.

Return

Return Type
nvarchar(2000)

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_DISCOUNTAVAILABILITY_MEMBERSLEVELSLIST
            (
             @DISCOUNTAVAILABILITYID uniqueidentifier
            )
            returns nvarchar(2000) AS  

            BEGIN 
             DECLARE @MEMBERSLEVELSLIST nvarchar(2000)

             SELECT @MEMBERSLEVELSLIST = COALESCE(@MEMBERSLEVELSLIST + '; ', '') + (MEMBERSLEVELSLIST.MEMBERLEVEL)
             FROM
                (select (MEMBERSHIPPROGRAM.NAME + ', ' + coalesce(MEMBERSHIPLEVEL.NAME, '<any level>')) MEMBERLEVEL  
                    from dbo.DISCOUNTAVAILABILITYMEMBER
                    inner join dbo.MEMBERSHIPPROGRAM on DISCOUNTAVAILABILITYMEMBER.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
                    left outer join dbo.MEMBERSHIPLEVEL on DISCOUNTAVAILABILITYMEMBER.MEMBERSHIPLEVELID = MEMBERSHIPLEVEL.ID
                    where DISCOUNTAVAILABILITYID = @DISCOUNTAVAILABILITYID) MEMBERSLEVELSLIST

             RETURN @MEMBERSLEVELSLIST
            END