USP_INSERT_DIRECTORYOPTSTATUS

create procedure dbo.USP_INSERT_DIRECTORYOPTSTATUS
  @RecordID uniqueidentifier,    
  @OptStatus bit 
as
begin
    declare @CHANGEAGENTID uniqueidentifier;
    exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
    if @OptStatus=1  
        begin  
            if not exists (select 1 from [DirectoryOptStatus] where [RecordID]=@RecordID)
            begin
                insert into [dbo].[DirectoryOptStatus]    
                ([RecordID] , [OptOut], [ADDEDBYID], [CHANGEDBYID])    
                values    
                (@RecordID , @OptStatus, @CHANGEAGENTID, @CHANGEAGENTID)  
            end   
       end   
   else  
       begin  
        delete from [dbo].[DirectoryOptStatus] where [RecordID]=@RecordID  
       end
end