This is what I finally used:

DROP TABLE IF EXISTS #DataSource;

CREATE TABLE #DataSource
(
    [ID] INT
   ,[GroupName] VARCHAR(12)
   ,[RuleName] VARCHAR(12)
  ...

I forgot to mention, the column list is not fixed, its dynamic.  Your solution only works for a fixed column list.

This is what I started with, but haven't found a...

Unless the data is delimited with the same number of spaces with the same type of data in the same columns, its not the simplest of tasks.  I agree with...

Which SQL Server are you on?

May look at the script library (https://www.sqlservercentral.com/scripts) for a String Split function.

DECLARE @string VARCHAR(50) = '1,2,3,4,5' ;
DECLARE @separator CHAR(1) = ',' ;
SELECT * FROM [Country] WHERE [Id] IN ( SELECT * FROM STRING_SPLIT( @string , @separator ) ;

Sticky situations.  On one hand people are entitled to their privacy.  But, on the other hand, entities (companies, governments, etc.) have security needs.  Example: Landlords are looking for ways to...

If I'm understanding you correctly, the users do not have connect privileges to the database.  Assuming you actually want them to be able to connect to the database, the following...

The following SQL query retrieves only the time as you'd like:

SELECT [TimeOnly] = FORMAT( [DateTimeCol] , N'hh\:mm\:ss' )
FROM [Job info$] ;

Now, if you need to persist the...

No, the temp table is for illustration only.  The query is something like:

SELECT [Time Reported] ,
       [TimeOnly] = CONVERT( TIME ,...

Try something like below.  Replace the temp table and column names with you table and columns names) this:

CREATE TABLE [#TimeReported]
(
   [ID]    ...

I prefer to use UTC at both the server level and the database level and perform all internal Application and Database logic with UTC.    Logic in the UI (or...