Hello Casper,

According to my knowledge of deadlocks,

Deadlocking occurs when two or more user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has locked. When this happens, SQL Server resolves the deadlock by automatically aborting one process, the "victim" process, allowing the other processes to continue.

The aborted transaction is rolled back and an error message is sent to the user of the aborted process. Generally, the transaction that requires the least amount of overhead to roll back is the transaction that is aborted.

So, theoritically, in your case, the table should not be populated at all.

Please refer to the below articles on handling deadlocks:

http://sqlserverpedia.com/wiki/Handling_Deadlock_Conditions_with_TRY_/_CATCH

http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/

Let me know if it solves your query...