I'm not sure that all the answers given in this thread are correct?

The WHERE clause, if indented, looks like this:

WHERE 1 = CASE WHEN T.record_Key_4 = '1'...

Now you've said that, we want to see the query plan.

;with A(A) as (select 0 from (values (0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) A(A))
select row_number() over (order by (select null)) ID,
       o.quantity,
    ...

This is not as fast as Jeff's method but is a more straight forward way of writing the SQL:

SELECT * 
  FROM #RMmaster m
 WHERE...

Then how would i calculate the number of loops?

I thought it would be something like [TotalNumberOfRecords]  MOD 100000?

Also when i write this value to a SSIS variable, how do...

https://en.wikipedia.org/wiki/Hole_punch#Multiple_hole_punches

Most...

Personally I'd just leave it...

Why are you outputting this line, whatever the error?

PRINT 'Attempt to insert duplicate PK in dbo.PersonWithUnviewedAlerts';

What if it's caught due to a different error?

Looks ok to me. I would only do it with dynamic SQL if the list of tables is going to change. If they are fixed then just hard code an...

You could insert the results from each query into a temporary table, then query the temporary table:

CREATE TABLE #Temp
(
    TableName sysname NOT NULL
 ...

From the limited information you have provided in your question and the error message I would guess that column PROCSTATUS_NUM is not a numeric data type (maybe it's character?) and...

Put it in a common table expression and subtract it in a select from the CTE.

;WITH CTE AS
(
SELECT Count(*) AS 'Count of Tranactions',
    ...

Not sure I can answer your question but we used to have some SQL Server instances running on VMs, each server was running on a dedicated machine with just one...

too late!

• This reply was modified 5 years, 7 months ago by Jonathan AC Roberts.

Here's another way of doing it using cross applys to work through the backslashes:

SELECT i.Result, a.line
  FROM DATACONTENT a
 CROSS APPLY(VALUES (SUBSTRING(a.line,CHARINDEX('\',a.line,3)+1,8000))) b(line)
 CROSS APPLY(VALUES (SUBSTRING(b.line,CHARINDEX('\',b.line)+1,8000)))...