USP_PRINTMEMBERSHIPCARDSPROCESS_GETPARAMETERS

Retrieves parameter settings for a given print membership cards process parameter set.
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_PRINTMEMBERSHIPCARDSPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier = null
            )
            as
                set nocount on;

                select
                    [NAME],
                    [DESCRIPTION],
                    MEMBERSHIPPROGRAMID,
                    MEMBERSHIPLEVELID,
                    IDSETREGISTERID,
                    MEMBERSHIPCARDFORMAT,
                    CREATEOUTPUTIDSET,
                    OUTPUTIDSETNAME,
                    OVERWRITEOUTPUTIDSET,
                    case 
                        when LETTERTEMPLATEID is null then (select top 1 ID from dbo.LETTERTEMPLATE where dbo.LETTERTEMPLATE.LETTERTEMPLATETYPECODE = 8) 
                        else LETTERTEMPLATEID
                    end as LETTERTEMPLATEID,
                    case 
                        when LETTERTEMPLATEID is null then (select top 1 LETTERFILENAME from dbo.LETTERTEMPLATE where dbo.LETTERTEMPLATE.LETTERTEMPLATETYPECODE = 8) 
                        else (select LETTERFILENAME from dbo.LETTERTEMPLATE where dbo.LETTERTEMPLATE.ID = LETTERTEMPLATEID)
                    end as LETTERTEMPLATEFILENAME,
                    LIMITTO
                from
                    dbo.PRINTMEMBERSHIPCARDSPROCESS
                where
                    ID = @ID;

                return 0;