Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @TimeStart TIME = '00:00:00'
- DECLARE @TimeEnd TIME = '00:19:59'
- DECLARE @Iterator INT = 0
- WHILE @Iterator < 72
- BEGIN
- SET @Iterator = @Iterator + 1
- INSERT INTO TestDB.dbo.Dashboard_DayCalls VALUES(@TimeStart, @TimeEnd, CAST(@TimeStart AS TIME(0)), 0, 0, 0, 0)
- SET @TimeStart = DATEADD(MINUTE, 20, @TimeStart)
- SET @TimeEnd = DATEADD(MINUTE, 20, @TimeEnd)
- END
Advertisement
Add Comment
Please, Sign In to add comment