Thank you for all the comments so far.

Could you expand on what you mean by reordering the transaction and how i might relate that to a select statement

I also noticed a blog that mentioned using try and catch around the statement so that if the statement failed due to a deadlock error it would automatically try again which sound quite neat ?

Thanks

Frant101