USP_RECORDOPERATION_TITLECODEDEFAULTSCLEARGENDER

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

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