Forum Discussion
Time interval
Hi there, See image below. In the left I have SQL Server table called example with two ID's And DTTM columns. I need it to capture 15 running min interval with reseting the loop (every 15 min set...
Look at the Excel sheet the interval is reset everytime the running total reach 15 min
Remember 10:12 was the cutting point now we are in 0 again
therefore 10:26 - 10:12 = 14 (we need 1 more to get 15) than 10:32 - 10:26 = 6
6 + 14 = 20 is >= 15 yes so 10:32 is the correct result
In another word is the running total of delta need to reach 15 min and reset again to 0 and start over thats way your windows of 15 min bucket won't produce the expected result it has to be recursive like TSQL
