This question might not be new in forums , but struggling to get the expected out put.
Please any body share the similar requirements if we face with solutions.
I would like to find average of total transactions for every 15 min.
create table logger (starttime datetime, endtime datetime, response bit) starttime endtime response 2019-10-14 15:08:38.533 2019-10-14 15:08:38.533 0 2019-10-14 15:08:40.533 2019-10-14 15:08:42.563 0 2019-10-14 15:09:40.533 2019-10-14 15:10:43.563 0 2019-10-14 15:09:41.533 2019-10-14 15:10:43.563 1
Below is the script i am using to generate number of seconds.
tried with below articles but no luck to achive the goal.
SELECT DATEDIFF(SECOND,STARTTIME,ENDTIME) FROM logger