Presumably, you've tried this and it did not work out the way you wanted?

SELECT *
FROM T1
    JOIN T2
      ...

Getting started with SSIS is a bit of a learning curve. I recommend you read a few of the stairway articles (link) to help you understand how everything fits...

Understood. But you mentioned 'SQLJob timings' and I was simply wanting to confirm that you had referred to this in error.

Hi Phil,

a) Whether a row is good or not - NOT

b) If a row is considered bad, how should its revised InTime or OutTime be derived? -

You mean the Event Viewer, presumably? OK, I don't know what to suggest...

OK, does it happen randomly, or only at set times?

Your expected results ignore rows with InTime from 28-31 May, presumably because these rows are considered 'good'? - No, missed punch out for the 28th. I just described two...

Your expected results ignore rows with InTime from 28-31 May, presumably because these rows are considered 'good'?

But if row 3 (28th) is good, why do you want to use its...

Is this something which has just started happening? If so, do you have any new jobs running which get data from other sources?

Welcome to the forum.

Please start a new thread, rather than hijacking this one.

Also, if you want...

DROP TABLE IF EXISTS #test2;

CREATE TABLE #test2
(
    tran_log_writes VARCHAR(8000) NULL
);

INSERT #test2
(
    tran_log_writes
)
VALUES
(N'db1: 245471085 (68491820 kB)');

SELECT t.tran_log_writes
     ...

This is easy in SSIS, if you are open to that.

Can you confirm that your DbaTools library is stored in the same location as found when running the following?

$env:PSModulePath -split ';'

(As I think some file locations differ...

Something like this?

WITH CIds
AS (SELECT ChannelID = CAST (value AS INT)
    FROM STRING_SPLIT(@ChannelIDs, ','))
SELECT dc.*
FROM #DeviceChannel dc
    JOIN CIds
  ...

You are right in suggesting that a CTE won't work in this case.

You might want to try experimenting with SYNONYMs. Aliases are limited in scope to the query in which...