Rn = ROW_NUMBER() OVER (ORDER BY o.object_id, o1.object_id) * 15 number of 15 minute intervals in a year */ IF (OBJECT_ID('tempdb.#Intervals') IS NOT NULL) , DATEADD(MINUTE, c.rn + c.rn1, DATEADD(DAY, -1, GETDATE())) SELECT DATEADD(MINUTE, c.rn, DATEADD(DAY, -1, GETDATE())) , rn1 = ROW_NUMBER() OVER (PARTITION BY o.object_id SELECT rn = ROW_NUMBER() OVER (ORDER BY o.object_id, o1.object_id) IF (OBJECT_ID('tempdb.#Calls') IS NOT NULL) You'd likely want to make the #Intervals table permanent.Д¬reate the testbed, and populate some sample data: USE tempdb

In example, I'm using temporary tables for both tables. This is a classic example of how a 'Numbers table' can really help get the results you need.Д®ssentially, you create a table containing the 15 minute increments you desire, then join your table to obtain an aggregate number of calls for each 15 minute increment. Is there a better way to do this? DECLARE DATETIME = DATETIME = GETUTCDATE() Upto tried the following query, however it doesn't work properly. My requirement is to get the count of Call Records between every 15 minutes of duration. I am passing two parameters and to my stored procedure.

Sql server minus minutes to getdate