Just curious - why not use the built-in...

Sorry - I am not in a position right now where I can write any code.  These are all things...

I can think of a couple of ways - pull the full list, loop over each item -...

Would I be able to give each row a Label?

,CASE WHEN datepart(hour, dt.dt_stamp) < 8 THEN 1

WHEN datepart(hour, dt.dt_stamp) < 16 THEN 2

ELSE 3

END as 'HrReported'

Instead of having a...

Would I be able to create different output files based on in the SP?

,CASE WHEN datepart(hour, dt.dt_stamp) < 8 THEN ..... Create output file1

WHEN datepart(hour, dt.dt_stamp) < 16 THEN...

For SSIS - you don't need an execute process tasks if you use WinSCP.  There is a .NET component available that can be used in a script task and a...

I would do this in SSIS - but then again, I have already done this in SSIS so I already have a template available to build a new project.  It...

What problem are you having?  I would put that CASE expression in another CROSS APPLY.  Then it can be included in the SELECT and the GROUP BY as any other...

Yeah - you can probably build...

It would be placed after the End...

I have seen other methods - for example, some will put the semi-colon as the only item on the line:

IF 1...

You can break it out any way you want - now that you have your datetime column it is just a matter of defining the value.  How you go about...

Sorry - having problems with copying:

Declare @start_date datetime = '20220101'
        @end_date datetime = '20220131';

Declare @ts_start bigint = cast(1000 As bigint)...

I had posted another response - not sure where it went.  As I stated before - you should calculate the start/end range of the t_stamp column instead of converting that...

Looks like there was a copy/paste error - the statements should be:

Declare @current_date datetime = '2022-01-12 10:22:21.183';

Declare @ts_start bigint = datediff_big(ms, '1970-01-01 00:00:00.000', cast(@current_date - 1 As...

semi-colon is a statement terminator.  Why would you need a semi-colon 'before' the WITH?