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...

Is it possible to exit the proc without falling thru to the DROP TABLE? What about the start of the proc? If the temp table already exists, does the...

What about this?:

Update A Set A.[Fname] = B.[Fname]
  from [Reporting].[dbo].[D02_CallLog] A 
  inner join [Reporting].[dbo].[D02_CallLog] B
    on A.[CallID] = B.[CallID]
 ...

UPDATE a
    SET a.Fname=b.Fname
   FROM [dbo].[D2_CallLog] a
  CROSS APPLY(SELECT TOP(1) *
          ...

As a guy who constantly advocates for ANSI/ISO standards, I would like to point out that the CONCAT is not SQL but local dialect. The correct syntax is in...

IIF is so unlike other other functions and expressions in SQL that it shouldn't be there.  That is, nowhere else in SQL does it enclose conditions and the...