Maybe this will shed some light on the subject:

DECLARE @testnum DECIMAL(18,2);
SET @testnum = 9.6;
SELECT ROUND(9.6,0);
SELECT ROUND(@testnum,0);
SET @testnum = 99.6;
SELECT ROUND(99.6,0);
SELECT...

Now using table aliases, which is what you should be using:

INSERT INTO
  [Tbl_ComputerInventory]
  (
    [ISOCountryAbb3]
    , [SiteNumber]
    , [ComputerName]
    ,...

Also, your code reformatted and column Fields5-10 treated as a single column:

INSERT INTO
  [Tbl_ComputerInventory]
  (
    [ISOCountryAbb3]
    , [SiteNumber]
    , [ComputerName]
   ...

Here is one for you all:
http://www.theregister.co.uk/2018/01/02/intel_cpu_design_flaw/

I think it depends.  I have Jeff's delimited split functions in a DBAUtilities database and I can use them in other databases on my laptop.  It would help if posted...