USP_RELATIONSHIPCONFIGURATION_CONFIGUREFORREVENUEBATCH

            create procedure dbo.USP_RELATIONSHIPCONFIGURATION_CONFIGUREFORREVENUEBATCH
            (
                @CONSTITUENTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
            begin
                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                begin try
                    insert into dbo.RELATIONSHIPCONFIGURATION
                    (
                        ID,
                        GENDERCODE,
                        APPLIESTOINDIVIDUALS,
                        APPLIESTOORGANIZATIONS,
                        APPLIESTOGROUPS,
                        RELATESTOINDIVIDUALS,
                        RELATESTOORGANIZATIONS,
                        RELATESTOGROUPS,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    select
                        BATCHRELATIONSHIPCONFIGS.ID,
                        BATCHRELATIONSHIPCONFIGS.GENDERCODE,
                        BATCHRELATIONSHIPCONFIGS.APPLIESTOINDIVIDUALS,
                        BATCHRELATIONSHIPCONFIGS.APPLIESTOORGANIZATIONS,
                        BATCHRELATIONSHIPCONFIGS.APPLIESTOGROUPS,
                        BATCHRELATIONSHIPCONFIGS.RELATESTOINDIVIDUALS,
                        BATCHRELATIONSHIPCONFIGS.RELATESTOORGANIZATIONS,
                        BATCHRELATIONSHIPCONFIGS.RELATESTOGROUPS,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    from dbo.UFN_RELATIONSHIPCONFIGURATION_CONFIGUREFORREVENUEBATCH(@CONSTITUENTID) BATCHRELATIONSHIPCONFIGS
                    left join dbo.RELATIONSHIPCONFIGURATION on BATCHRELATIONSHIPCONFIGS.ID = RELATIONSHIPCONFIGURATION.ID
                    where RELATIONSHIPCONFIGURATION.ID is null

                    update dbo.RELATIONSHIPCONFIGURATION
                    set    
                        RELATIONSHIPCONFIGURATION.GENDERCODE = BATCHRELATIONSHIPCONFIGS.GENDERCODE,
                        RELATIONSHIPCONFIGURATION.APPLIESTOINDIVIDUALS =  case when BATCHRELATIONSHIPCONFIGS.APPLIESTOINDIVIDUALS = 1 then 1 else RELATIONSHIPCONFIGURATION.APPLIESTOINDIVIDUALS end,
                        RELATIONSHIPCONFIGURATION.APPLIESTOORGANIZATIONS = case when BATCHRELATIONSHIPCONFIGS.APPLIESTOORGANIZATIONS = 1 then 1 else RELATIONSHIPCONFIGURATION.APPLIESTOORGANIZATIONS end,
                        RELATIONSHIPCONFIGURATION.APPLIESTOGROUPS = case when BATCHRELATIONSHIPCONFIGS.APPLIESTOGROUPS = 1 then 1 else RELATIONSHIPCONFIGURATION.APPLIESTOGROUPS end,
                        RELATIONSHIPCONFIGURATION.RELATESTOINDIVIDUALS = case when BATCHRELATIONSHIPCONFIGS.RELATESTOINDIVIDUALS = 1 then 1 else RELATIONSHIPCONFIGURATION.RELATESTOINDIVIDUALS end,
                        RELATIONSHIPCONFIGURATION.RELATESTOORGANIZATIONS = case when BATCHRELATIONSHIPCONFIGS.RELATESTOORGANIZATIONS = 1 then 1 else RELATIONSHIPCONFIGURATION.RELATESTOORGANIZATIONS end,
                        RELATIONSHIPCONFIGURATION.RELATESTOGROUPS = case when BATCHRELATIONSHIPCONFIGS.RELATESTOGROUPS = 1 then 1 else RELATIONSHIPCONFIGURATION.RELATESTOGROUPS end,
                        RELATIONSHIPCONFIGURATION.CHANGEDBYID = @CHANGEAGENTID,
                        RELATIONSHIPCONFIGURATION.DATECHANGED = @CURRENTDATE
                    from dbo.UFN_RELATIONSHIPCONFIGURATION_CONFIGUREFORREVENUEBATCH(@CONSTITUENTID) BATCHRELATIONSHIPCONFIGS
                    left join dbo.RELATIONSHIPCONFIGURATION on BATCHRELATIONSHIPCONFIGS.ID = RELATIONSHIPCONFIGURATION.ID
                    where 
                        RELATIONSHIPCONFIGURATION.ID is not null 

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch
            end