UFN_MEMBERSHIP_GETDESCRIPTION

Return

Return Type
nvarchar(255)
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
Definition

Copy


                create function dbo.UFN_MEMBERSHIP_GETDESCRIPTION
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(255)
                as begin
                    declare @DESCRIPTION nvarchar(255);

                    select
                        @DESCRIPTION =  dbo.UFN_MEMBERSHIPPROGRAM_GETNAME(MEMBERSHIP.MEMBERSHIPPROGRAMID) + ' - ' +
                                        dbo.UFN_MEMBERSHIPLEVEL_GETNAME(MEMBERSHIP.MEMBERSHIPLEVELID) + ' (' +
                                        dbo.UFN_MEMBERSHIPLEVELTERM_GETVALUE(MEMBERSHIP.MEMBERSHIPLEVELTERMID) + ')'
                    from
                        dbo.MEMBERSHIP
                    inner join
                        dbo.MEMBER on MEMBERSHIP.ID = MEMBER.MEMBERSHIPID
                    where
                        MEMBERSHIP.ID = @ID
                        and MEMBER.ISPRIMARY = 1;

                    return isnull(@DESCRIPTION, '');
                end