SQL Nested Loop

Question

I got stuck in a nested loop and would appreciate some advice.

Declare @monthNumber as Integer, @loopCounter as Integer

Set @monthNumber = 0
Set @loopCounter = 1

While @monthNumber <= 13 Begin
     While @loopCounter <=100 Begin
     @loopCounter = @loopCounter +1
     End
 @monthNumber = @monthNumber + 1
 End

I've abbreviated my code to the sample above; I have two loops in my main SQL query. The inner loop is to identify different records in my table 100 times, and the outer loop is to basically add one extra month to the @monthNumber variable so that when the code runs, I return 100 records for each of the 13 months into one table. When I run the code, the first inner loop runs perfectly, but ends without continuing to the next month via adding a 1 to the @monthNumber. Any suggestions?

You might want to add a tag to your question indicating what version of SQL you are using. — Dijkgraaf
– Dijkgraaf, Commented Apr 29, 2015 at 0:08

cha · Accepted Answer · 2015-04-29 00:12:07Z

1

You do not reset the @loopCount variable back to 1:

Declare @monthNumber as Integer, @loopCounter as Integer

Set @monthNumber = 0
Set @loopCounter = 1

While @monthNumber <= 13 Begin
     While @loopCounter <=100 Begin
     @loopCounter = @loopCounter +1
     End
 @monthNumber = @monthNumber + 1
 Set @loopCounter = 1
 End

answered Apr 29, 2015 at 0:12

cha

10.4k1 gold badge20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Nested Loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related