USP_PLEDGEREMINDERPROCESS_GETPARAMETERS

            CREATE procedure dbo.USP_PLEDGEREMINDERPROCESS_GETPARAMETERS
            (
                @id uniqueidentifier = null
            )    
            as
                set nocount on;

                select 
                    PLEDGEREMINDERPROCESS.NAME, 
                    PLEDGEREMINDERPROCESS.IDSETREGISTERID, 
                    PLEDGEREMINDERPROCESS.CREATEOUTPUTIDSET,
                    PLEDGEREMINDERPROCESS.OUTPUTIDSETRECORDTYPEID,
                    PLEDGEREMINDERPROCESS.OUTPUTIDSETNAME, 
                    PLEDGEREMINDERPROCESS.DATETYPECODE,
                    PLEDGEREMINDERPROCESS.DATE, 
                    PLEDGEREMINDERPROCESS.OVERWRITEOUTPUTIDSET, 
                    PLEDGEREMINDERPROCESS.BUSINESSPROCESSVIEWID,
                    PLEDGEREMINDERPROCESS.MARKREMINDERSSENT,
                    PLEDGEREMINDERPROCESS.SENTDATETYPECODE,
                    PLEDGEREMINDERPROCESS.SENTDATE,
                    PLEDGEREMINDERPROCESS.EXCLUDEMAIL,
                    PLEDGEREMINDERPROCESS.EXCLUDEPHONE,
                    PLEDGEREMINDERPROCESS.EXCLUDEEMAIL,
                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFINCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'INCLUSION',
                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'EXCLUSION',
                    BUSINESSPROCESSCOMMPREF.DATETYPECODE as EXCLUSIONDATETYPE,
                    BUSINESSPROCESSCOMMPREF.ASOFDATE,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEDECEASED,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEINACTIVE,
                    PLEDGEREMINDERPROCESS.CUSTOMPARAMETERDATAFORMITEM,
          PLEDGEREMINDERPROCESS.ISRECURRINGGIFTS,
          PLEDGEREMINDERPROCESS.ISPLEDGES,
          PLEDGEREMINDERPROCESS.OUTPUTGROUPINGCODE,
                    PLEDGEREMINDERPROCESS.EXPORTDEFINITIONID
                from 
                    dbo.PLEDGEREMINDERPROCESS
                left outer join dbo.BUSINESSPROCESSCOMMPREF on PLEDGEREMINDERPROCESS.ID = BUSINESSPROCESSCOMMPREF.BUSINESSPROCESSPARAMETERSETID
                where 
                    PLEDGEREMINDERPROCESS.ID = @id;