This site's for Microsoft SQL Server, and as such you'll probably find better help with this at a dedicated MySQL site.

First time I've ever seen a single-resource deadlock. Interesting.

This can be fixed if you can change the code for the UPDATE statement. Can you?

In your update trigger you can use IF UPDATED(ColumnName) to check whether something other than the created and updated dates were updated, and only proceed with the trigger if other...

Can you please post the CREATE TABLE for SalBranch, and the CREATE INDEX statement for each index on it.

My answer was a bit flippant, but the point is there's no minimum row count to have before creating an index. What the index is created on (and, even if...

GO is not a T-SQL command. It's a Management Studio batch terminator. When SSMS (and several other clients) encounters a GO, it sends the text up to that point to...

Not a picture of the deadlock graph. The graph itself, either saved as a file (.xdl) or paste the text of it.

Can you post the deadlock graph?

A deadlock has to be two sessions  (or more) and two resources (or more), so there's something else involved.

And an old blog post discussing the subject (also read the posts that it links to): http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/

Hit google and look for 'dynamic pivot', that should be enough to get you started.