I have no way to provide the code that generated the image table because it was a scada software that created it and it will store only data in the...

the Corrente_L1 will receive values ​​every 15 min, I need the total of  Corrente_L1 for the respective period, if it is for the month, it should return the total for...

• This reply was modified 2 years, 6 months ago by  usertest.

I would like the total of each period separated by each respective research period, for example the week of 05/18/2022 would return the total of each of the last seven...

so the code used to create the table was this it's a identity table so none value would repeat

CREATE TABLE Table1 (Corrente_L1 INT IDENTITY(0,1), E3TimeStamp DATETIME);

 DECLARE...

I need the code to work with days, weeks and months  to so I tought that working with minutes and the average number of days in the month would simplify...