If someone is interested on code that is actually readable and without errors.

CREATE TABLE [dbo].[GL_Source]
(
  [GLS_ID] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_GLS_ID] DEFAULT (NEWID()),

By the way, you shouldn't be updating the whole table every time. Use a WHERE clause to limit the work that needs to be done.

You could simply update in a set-based way without going row by row.

UPDATE i SET
  [InvoiceMethod]=c.PreferredInvoiceMethod
FROM tblCompany     AS c
JOIN tblWorkOrder    ...

Have you tried with the DelimitedSplit8K_Lead?
http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/

I would check these expressions. You might be confused on what you're doing.
LEFT(cnd.Name, CHARINDEX(':', LEN(cnd.Name) - 1))
LEFT(cnd.Name, CHARINDEX(' ', REVERSE(LEN(cnd.Name))))

And I usually work on an opposite way

SELECT
    o.name              AS ObjName,
    ix.name             AS IxName ,
    ic.index_column_id  AS IxColId
FROM sys.objects        o