UFN_COMBINATIONAVAILABILITY_MEMBERSLEVELSLIST

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

Return

Return Type
nvarchar(2000)

Parameters

Parameter	Parameter Type	Mode	Description
@COMBINATIONAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_COMBINATIONAVAILABILITY_MEMBERSLEVELSLIST
            (
             @COMBINATIONAVAILABILITYID 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.COMBINATIONAVAILABILITYMEMBER
                    inner join dbo.MEMBERSHIPPROGRAM on COMBINATIONAVAILABILITYMEMBER.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
                    left outer join dbo.MEMBERSHIPLEVEL on COMBINATIONAVAILABILITYMEMBER.MEMBERSHIPLEVELID = MEMBERSHIPLEVEL.ID
                    where COMBINATIONAVAILABILITYID = @COMBINATIONAVAILABILITYID) MEMBERSLEVELSLIST

             RETURN @MEMBERSLEVELSLIST
            END