Thanks David,

I broke the process into 2 parts...

I process anything with a length less than 8000 using varchar. This is the bulk of those records.

I used the example code...

The two tables are ScanResultStage and ScanResultBuild

Each contain a single result column which is text, because of the fact that the size can easily surpass 8000 chararacters. The data...