Select SourceId, PurchasOrderID, AppearsOn, RowUpdateDateTime, 
       [1] comment1,
       [2] comment2,
     ...

I came up with the following self referencing CTE but its not moving along the levels, so IDK.

With CTE
  AS(
SELECT Dimensions,Management,[Description], [Level]
FROM [dbo].[Hier_table]
WHERE Dimensions =...

Here's a way of writing it without ORs, but I'm not sure it's any better:

WHERE iv.AccountCode = @AccountCode
  AND iv.ItemID = @ItemID
  AND iv.VarianceID =...

• This reply was modified 6 years, 7 months ago by Jonathan AC Roberts. Reason: Added EXCEPT

WHERE 1 = CASE

WHEN T.record_Key_4 = '1' OR T.Record_Key_5 NOT IN('I', 'X') THEN CASE WHEN PS.popup_gid = 2 THEN 1 eLSE 0 END

ELSE CASE WHEN PS.popup_gid = 5 THEN...

Yes, I was...

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