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

p.s.  I followed your "casing" in my code but the "prettifier" in the code window changed all the SQL Code to upper case for display.

The SQL code is not all...

Thanks Ant-Green,

Ok, to ask a dumb question to clarify, I should install VS (either 2019 or 2022) I then go to manage extensions & download/install the SSIS/RS/AS packages.

I should...

You mention that there would be a lot of changes required if you change the format of the column. But wouldn't there also be lots of changes required to use...

Yes, but...