InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:16:37 GMT20http://www.sqlservercentral.com/Forums/Topic717733-8-1.aspxLovelyThank YouFri, 15 May 2009 07:36:59 GMTdebbie.coateshttp://www.sqlservercentral.com/Forums/Topic717733-8-1.aspx[quote][b]debbie.coates (5/15/2009)[/b][hr]Is there a way that i can create an after update trigger that will detect if there is a corresponding record with a 999 prefix and update that record?[/quote]Try something like this in your triggerupdate bdset AccountName = ins.AccountName, BankBuildingSocietyName = ins.BankBuildingSocietyName , BankAddress = ins.BankAddress , BankPostcode = ins.BankPostcode, BankSortCode = ins.BankSortCode , BankAccountNumber = ins.BankAccountNumber, RollRefNumber = ins.RollRefNumber from BankDtails bdinner join inserted ins on db.ProjectID = convert(int,'999' + convert(varchar,ins.ProjectID))I'm assuming that projectid is an int, if not you won't need the convert statements in the join.Fri, 15 May 2009 06:19:24 GMTRP_DBAhttp://www.sqlservercentral.com/Forums/Topic717733-8-1.aspxCan anyone tell me if its possible to do thisI have a table called BankDtails with the following fieldsProjectIDAccountNameBankBuildingSocietyNameBankAddressBankPostcodeBankSortCodeBankAccountNumberRollRefNumberThe field ProjectID will be something like 10024In the same table I may also have a record with a ProjectID of 99910024the second record will always be proceeded with a 999Is there a way that i can create an after update trigger that will detect if there is a corresponding record with a 999 prefix and update that record?I would appreciate any help on this.Thank YouFri, 15 May 2009 03:54:55 GMTdebbie.coates