WorkAkkaunt

Сценарий на установление времени в таблице

Aug 28th, 2019
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.37 KB | None | 0 0
  1. DECLARE @TimeStart TIME = '00:00:00'
  2. DECLARE @TimeEnd TIME = '00:19:59'
  3.  
  4. DECLARE @Iterator INT = 0
  5.  
  6. WHILE @Iterator < 72
  7. BEGIN
  8.     SET @Iterator = @Iterator + 1
  9.     INSERT INTO TestDB.dbo.Dashboard_DayCalls VALUES(@TimeStart, @TimeEnd, CAST(@TimeStart AS TIME(0)), 0, 0, 0, 0)
  10.     SET @TimeStart = DATEADD(MINUTE, 20, @TimeStart)
  11.     SET @TimeEnd = DATEADD(MINUTE, 20, @TimeEnd)
  12. END
Advertisement
Add Comment
Please, Sign In to add comment