TR_CLIENTUSERSSALTCIPHER_INSERT

          create trigger [dbo].[TR_CLIENTUSERSSALTCIPHER_INSERT] on [dbo].[CLIENTUSERSSALTCIPHER] after insert not for replication
          as
          begin
              insert into [CLIENTUSERSSALTCIPHERHISTORY] 
              (
                  [CLIENTUSERSID]
                  ,[SALTEDKEY]
                  ,[CIPHERHISTORYID]
                  ,[ADDEDBYID]
                  ,[CHANGEDBYID]
              ) 
              (
                  select 
                      INSERTED.CLIENTUSERSID
                      , INSERTED.SALTEDKEY
                      , CUCH.ID
                      , INSERTED.ADDEDBYID
                      , INSERTED.CHANGEDBYID 

                      from INSERTED 
                      inner join CLIENTUSERSCIPHER        as CUS    on INSERTED.CLIENTUSERSID    = CUS.CLIENTUSERSID
                      inner join CLIENTUSERSCIPHERHISTORY as CUCH on CUCH.CLIENTUSERSID        = INSERTED.CLIENTUSERSID 
                and CUCH.CIPHER = CUS.CIPHER
              )
          end