Just a little OCD when it comes to formatting code:
select top 1
  t.*
from (select
        4 as slot,
        UDCONT4,
        'Record' as RC,
       ...

No create statement for the #Sessions table.

First, is there a reason for this: cast(sbo.docentry as nvarchar(50)) = cast( lv.docentry...

Only thing I could suggest is BINARY_CHECKSUM.

Based on the pictures, not really.  For real assistance we would need the execution plans as .sqlplan files, the deadlock graph as an .xml file (may need to upload as...

Depends on SQL Server version, from BOL:
For SQL Server 2014 and earlier, allowed input values are limited to 8000 bytes.

The specific page:  https://msdn.microsoft.com/query/dev14.query?appId=Dev14IDEF1&l=EN-US&k=k(hashbytes_TSQL);k(sql13.swb.tsqlresults.f1);k(sql13.swb.tsqlquery.f1);k(MiscellaneousFilesProject);k(DevLang-TSQL)&rd=true

This:

if OBJECT_ID('tempdb..#answers') is not null
  drop table #answers;
Create table #answers
(
 id int,
 value varchar(50),
)
go
INSERT INTO #answers
VALUES(1,'1,2,3,4'),
 (2,'5,2'),
 (3,'3,4')
GO

Great, emoticans in the code posted above, hope you all can decipher it.

The requirement for the XML coming from external sources is that the XML must include the cidneNS namespace.  If this namespace is not included in the XML (as I showed) it...

The other issue I did see is that if node elements were missing the nodes() returned empty strings for character columns, 0 for integer columns, 1900-01-01 for date columns all...