The new STRING_SPLIT with the 3rd operand is great for this.  The old STRING_SPLIT without it is not.  Even MS has stated that the order of the output is...

As a test I used this date range function https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function to insert 6.3M rows into a temporary table to see which is faster. There doesn't seem to be  lot...

Guys... the OP doesn't know which domains contain a "B" ahead of time.  He was just explaining the desired results for the test data he provided.  Or, at least,...

Or slightly more concisely

DECLARE @JobDomain int
SET @JobDomain = 1

SELECT *
  FROM dbo.TestTable
 WHERE JobDomain = @JobDomain
   AND (TestType = 'B'
    ...

DROP TABLE IF EXISTS #T;

SELECT *
  INTO #T
  FROM (VALUES ('1A','E'),('1A','IR'),('1A','N'),('1A','SC'),('1A','SCIR'),
              ...

You could insert all the data that needs to be updated into a temporary table with a clustered index on BaseId, also as Scott says make sure the clustered index...

SELECT '2500------' AS Field1,
       '------' AS Field2,
       '------' AS Field3,
     ...

SELECT d.*, p.CurrentSizeGB - d.CurrentSizeGB size_diff 
  FROM [dev_db_size] d
 INNER JOIN [prod_db_size] p
         ON RIGHT(p.FileName, 3) =...

Using THROW will save...

While I'm not an AWS expert by any means when you deploy an RDS instance of SQL it looks to in the backend just put the MDF/NDF/LDF/BAK/TRN all on...

The purpose of a data warehouse is to be able to query the data quickly. If you only insert values that have changed with start and end dates, the table...

with cte as (select 'PartNbr|#@|Machine|#@|CCode|#@|Cost|#@|  ttxx23|#@|plc1|#@|  ttxx24|#@|plc2' Value)
,cte2 as (select x.value, x.position from cte
           cross...

Thanks for spotting that Jeff. I deliberately wrapped an LTRIM around the return value so if a manually written csv sometimes had comma space or just comma it would return...

If you use this nvarchar(MAX) STRING_SPLIT function

You can do it with the following code:

with cte as (select 'PartNbr|#@|Machine|#@|  ttxx23|#@|plc1|#@|  ttxx24|#@|plc2' Value)
,cte2 as (select x.value,...

I need to add a single quote in each of the alternate characters. The input string could be a variable length.

As an example:

Input String: 5,1,6,1,69,1

output: '5',1,'6',1,'69',1

Input String: 5,1,6,1,3,2,5,3,69,1

output:...