TSQL Nested loop only executes inner loop

Question

Probably missing something obvious, but I cannot get a nested while loop to function properly. If I comment out the inner while, the outer while works as expected, but otherwise only the inner while is executed. I've culled out the actual code to be executed to try and help figure this out, which is why it's just showing the contents of the variables. I'm sure it's something simple I'm missing but I've been banging my head on this for a while now so hopefully someone can help!

DECLARE @WeekCounter AS int
DECLARE @ClientCounter AS int

SET     @WeekCounter = 1
SET     @ClientCounter = 1

WHILE @ClientCounter <= 3
    BEGIN
        WHILE @WeekCounter <= 2
            BEGIN
                SELECT @ClientCounter,@WeekCounter

                SET @WeekCounter = @Weekcounter + 1
            END

        SET @ClientCounter = @ClientCounter + 1
    END

Thanks

Never mind, I need to set the variable for the second loop inside the first to reset it... Feeling stupid. Working code - — jameschg
– jameschg, Commented Oct 17, 2017 at 8:17

Marian Nasry · Accepted Answer · 2017-10-17 08:27:05Z

2

Working code -

DECLARE @WeekCounter AS int
DECLARE @ClientCounter AS int

SET     @ClientCounter = 1

---------Set client info from counter--------------
WHILE @ClientCounter <= 3
    BEGIN
        SET @WeekCounter = 1
        WHILE @WeekCounter <= 2
            BEGIN
                SELECT @ClientCounter,@WeekCounter
                SET @WeekCounter = @Weekcounter + 1
            END
        SET @ClientCounter = @ClientCounter + 1
    END

edited Oct 17, 2017 at 8:27

Marian Nasry

8159 silver badges22 bronze badges

answered Oct 17, 2017 at 8:18

jameschg

393 bronze badges

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

Collectives™ on Stack Overflow

TSQL Nested loop only executes inner 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