First thing to do is look at the code run by both processes to see what may have caused the deadlock.

The next thing you could do is implement...

Have you tested the code both ways to see which works?

An easy one.

This looks like it may be more of a user defined error than a SQL Server error.  I base this on the fact that there is no error number in...

Is there a question here?

Could you post the full and complete error message you receive.  Also, are there any other errors in the SQL Server error log at the same time?

I guess it is my turn.

 I received a call this morning (2019-02-15) at approximately 12:50 AM MDT from Springs Village where my dad was in rehab.  He passed...

Yes, and you can insert those values into a properly defined table (permanent, temporary, or variable).

create table #Sample(Color varchar(32), QuantitySold int);

insert into #Sample(Color,...