I've  put an LTRIM on the output to make it the same as the SQL Server version, also it was searching the string for the delimiter one short of the...

Great, thank you for the correction. Here is another Problem to consider

INSERT INTO @Test SELECT value FROM dbo.STRING_SPLIT('Abc, Ced, Def, ', ', ')

gives "Abc", "Ced" and "Def,...

Is this what you want?

SELECT a.Eid , b.typ
  FROM sample_data a
 CROSS JOIN sample_data b
 ORDER BY 1, 2

So you are just trying to make sure you don't load the same file twice. Maybe if you create another table of all the files you have loaded, insert a...

Why are you worried about getting duplicates?

If you make sure the same file isn't loaded twice then would that solve your problem?

Not sure if I fully understand your problem but would a query to load from the landing table into the appropriate table like this do?

INSERT INTO MainTable
(
...

I'm having the following problem with the solution. The following call returns 'bc' as the only value, not 'Abc' as I would suppose:

DECLARE @Test table (Field...

To save space, ENCRYPT the body (and other very long columns).  This process is rather slow, but it typically does save a lot of space.

And, using triggers, you can...

I see, I think an inner join would do the same job.

I can't see how your stored procedure is reusing a temporary table from another call. It looks...

LightVader said in the first...

I just started looking at your proc and the first bit of code:

--Create a temp table with the nodes & figures to execute
SELECT n.itemNum, 
...

I just started looking at your proc and the first bit of code:

--Create a temp table with the nodes & figures to execute
SELECT n.itemNum, 
  ...

Yep, as I said, C# has a ternary operator (? : ) that is logically similar to IIF, and VB has IIF, but that doesn't really have much to...

I don't think I'd blame this on...

I'm having an issue with a database that I recently moved from SQL 2014 to SQL 2019 (Standard in both cases).  The users get data from the database using...