This reminds a little of a similar topic from a few weeks ago

https://www.sqlservercentral.com/forums/topic/inconsistent-query-execution-times

One way could be to add the date and hour to the GROUP BY

select t.tagid, cast(v.ss_dt as date) day_dt, datepart(hour, v.ss_dt) hr,
     ...

For the denominator you could sum SIGN(ABS()) functions.  The SIGN function returns -1, 0, or 1 depending on if the input is negative, zero, or positive.  The ABS function returns...

Looks like if I add this in my query logic I'm getting the datetime desired

DATEADD(s,t_stamp/1000,'1969-12-31 20:00:00')

2024-02-01 01:00:00.000 2024-02-01 01:00:01.000

Struggle with doing the count of records per TagID within the...

CREATE TABLE [dbo].[tmp_sqlt_data_1_2022_05](
[tagid] [int] NOT NULL,
[intvalue] [bigint] NULL,
[floatvalue] [float] NULL,
[stringvalue] [nvarchar](255) NULL,
[datevalue] [datetime] NULL,
[dataintegrity] [int] NULL,
[t_stamp] [bigint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
[tagid] ASC,
[t_stamp] ASC
)WITH (PAD_INDEX =...

A good place to start could be with a query to generate the most recent 5 Friday dates...

Here are two ways.  My preference is for the second one.  Since the FORMAT function was introduced in SQL Server 2012 (afaik) it's been known to have performance issues.  Maybe...

IMHO, Steve Collins' post (with a tiny tweak (change fn.n to fn.value) in the 2nd bit of code) contains the winning entries for simplicity IF you don't mind any...

Using a tally function or GENERATE_SERIES maybe something like this

/* expand the date range using a tally function */
select v.calc_dt, count(*) active_policies
from #Policy p
   ...

A while ago when I looked into GitHub Copilot, the service was based on ChatGPT-3.5 which is/was quite inferior imo to the ChatGPT-4 which was available at the time. 

Back in the day, before SQL Server 2012 was previewed, I worked on a project which started with a blank database.  My teammate at the time started sending me articles...

We'll have to see how the OP replies.  Maybe my code only summed the part they want subtracted from the sum_qty

All right, some data.  This could be my only chance to use SQL for the day.  For my part, this week and until it's done, I'm working on web development. ...