declare @B_counter int
declare @A_counter int
set @A_counter = 0
set @B_counter = 0
WHILE @B_counter <= 10 begin
    
    WHILE  @A_counter <= 10 begin
        
        SET @A_counter = @A_counter + 1
        print 'inner loop'
    end 

    SET @B_counter = @B_counter + 1
    SET @A_counter = 0
    print 'outer loop'
end