USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPBASICCMSCOPY

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

                    set nocount on;                    
                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = MEMBERSHIPPROGRAM.NAME,
                @URL = CASE WHEN ISNULL(CAST(MP.SITEPAGESID AS BIT), 0) = 1 THEN dbo.UFN_BBNC_URL() + (SELECT TOP 1 VanityURL from dbo.VanityURL where PageID= MP.SITEPAGESID) ELSE '' END, 
                @DESCRIPTION = MEMBERSHIPPROGRAM.DESCRIPTION
                    from dbo.MEMBERSHIPPROGRAM
                    left join dbo.MICROSITEPAGE MP 
                        on (MP.OBJECTID = MEMBERSHIPPROGRAM.ID) and (MP.EXCLUDED = 0)
                    where MEMBERSHIPPROGRAM.ID = @ID;        

                    return 0;

                end