Join both tables to get the aggregate count of Calls between the 15 minute date ranges: SELECT i.DateStart INSERT INTO #Intervals (DateStart, DateEnd) For example if pass 2945 minutes it should return me 1 day 1 hour and 5 minutes. Rn = ROW_NUMBER() OVER (ORDER BY o.object_id, o1.object_id) * 15 Dear All, Is there any funtion that returns days and hours on passing of minutes to it. number of 15 minute intervals in a year */ The MAX () function returns the largest value of the selected column. IF (OBJECT_ID('tempdb.#Intervals') IS NOT NULL) The MIN () function returns the smallest value of the selected column. , 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.

Minus minutes in sql