Source Code for Me (s-c.me)

Copy Source | Copy HTML
TRUNCATE TABLE DevicesData
 
DECLARE @n int
SET @n = 999
DECLARE @List TABLE (n int)
WHILE @n >= 0 BEGIN
   INSERT INTO @List (n)
   SELECT @n
   SET @n = @n - 1
END
 
INSERT INTO DevicesData (DeviceId, Value)
SELECT A.n * 1000 + B.n, 0
   FROM @List A CROSS JOIN @List B
GO