Hello Dwayne,

I tried the script but it just keeps on running.

Here is the actual script:

WITH Tally (n) AS

(

SELECT TOP ((SELECT 1+CAST(4*MAX([hours]) AS INT) FROM TOTALS

where PERSON = '1010' and DATE between '02/05/2014' and '02/11/2014'

))

ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

FROM sys.all_columns

)

SELECT PERSON, DATE, [hours]=DATEADD(minute, 15*n, CAST('00:00' AS TIME))

FROM TOTALS a

CROSS APPLY

(

SELECT n

FROM Tally

WHERE n <= 4.*[hours]

) b

ORDER BY PERSON, [DATE], n;