Skip to content

Instantly share code, notes, and snippets.

@kristinaconley

kristinaconley/Loop Integer Variable

Last active December 17, 2015 20:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kristinaconley/5667973 to your computer and use it in GitHub Desktop.
Save kristinaconley/5667973 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Loop Integer Variable
/*************************************************************
Insert Timeframe 0 - 6 days into table variable.
*************************************************************/
DECLARE @integer Int
DECLARE @Projected TABLE (timeframe CHAR(10))
SELECT @integer = 0
WHILE @integer < 7
BEGIN
INSERT INTO @Projected(timeframe)
(SELECT @integer)
SET @integer = @integer + 1
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment