USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPLEVELBASICCMSCOPY

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(512)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@URL	nvarchar(max)	INOUT
Definition

Copy

      create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPLEVELBASICCMSCOPY
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(512) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @URL nvarchar(max) = null output
                ) as

                begin

                    set nocount on;

                    declare @BBNCURL nvarchar(1024) = dbo.UFN_BBNC_URL();
                    declare @MEMBERSHIPPROGRAMID uniqueidentifier;
                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = MEMBERSHIPLEVEL.NAME,
                        @DESCRIPTION = MEMBERSHIPLEVEL.DESCRIPTION,
                        @MEMBERSHIPPROGRAMID = MEMBERSHIPLEVEL.MEMBERSHIPPROGRAMID
                    from
                        dbo.[MEMBERSHIPLEVEL]
                    where 
                        (MEMBERSHIPLEVEL.ID = @ID);

                    select 
                        @URL = CASE WHEN ISNULL(CAST(MICROSITEPAGE.SITEPAGESID AS BIT), 0) = 1 then @BBNCURL + (SELECT TOP 1 VanityURL from dbo.VanityURL where PageID= MICROSITEPAGE.SITEPAGESID) ELSE '' END + '?mpl=' + cast(@ID as nvarchar(36))
                    from 
                        dbo.MEMBERSHIPPROGRAM 
                        left join dbo.MICROSITEPAGE    on 
                            (MICROSITEPAGE.OBJECTID = MEMBERSHIPPROGRAM.ID) and (MICROSITEPAGE.EXCLUDED = 0)
                    where
                        MEMBERSHIPPROGRAM.ID = @MEMBERSHIPPROGRAMID;

                    return 0;                            
                end