SQL Server Nested WHILE Loop Example

Introduction

Here I will explain how to use nested while loops in SQL Server with example.

Description

In previous articles I explained While Loop Example in SQL Server, Break or Exit while loop in SQL Server, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server. Now I will explain how to use nested while loops in SQL Server.

To use while loop in stored procedure we need to write the query like this

DECLARE @loop INT SET @loop = 0 WHILE @loop <= 10 BEGIN    SET @loop = @loop + 1    PRINT @loop END

If we run above query we will get output like as shown below

Output: 

If we want to Nested while loops we need to write the query like this

DECLARE @loop1 INT DECLARE @loop2 INT SET @loop1 = 1 WHILE @loop1 <= 3 BEGIN    SET @loop2 = 1    WHILE @loop2 <= 2    BEGIN        PRINT CONVERT(VARCHAR, @loop1) + ' * ' + CONVERT(VARCHAR, @loop2)+ ' = ' + CONVERT(VARCHAR, @loop1 * @loop2)        SET @loop2 = @loop2 + 1    END    SET @loop1 = @loop1 + 1 END

If we run above query we will get output like as shown below

Output: 

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email