USP_RESETGENDERDEFAULT_RELATIONSHIPCONFIGURATION

                    CREATE procedure dbo.USP_RESETGENDERDEFAULT_RELATIONSHIPCONFIGURATION
                    (
                        @ID nvarchar(100),
                        @CHANGEAGENTID uniqueidentifier = null
                    )
                    as begin
                        set nocount on;
                            if @CHANGEAGENTID is null  
                                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                            update
                                dbo.RELATIONSHIPCONFIGURATION
                            set
                                GENDERCODE = 0,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = getdate()
                            where GENDERCODE in (1,2);
                    end