While loop in view sql server. SQL While Loop exists.

While loop in view sql server So just because declare @SerialInfo table appears inside the loop, that doesn't mean that @SerialInfo is reinitialized as an empty table each time through the loop. on @SeanLange 's comment The variables that change @Counter and @NumPerson are not included in the inner query/inline view that contain the group by clause so it won't change. How to set variables in While Loop in Sql Server. This is how to use the So this is weird. My Cursor and Output. [NAME], C. The Overflow Blog Our next phase—Q&A was just the beginning “Translation is the tip of the iceberg”: A deep dive into specialty models. This guide will walk you through the basics of nested WHILE loops in SQL Server, However, I only need the select to loop through a few columns for this. You don't need a loop at all (in fact, you really should almost never need loops in SQL). '2024-07-23', 300. To get the all result in one window you could try CTE or #temp table. funcSplitToTable Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company The WHILE statement as used in various programming languages works in similar way in SQL Server. Viewed 7k times Hi I have a view which is used in lots of search queries in my application. How to use WHILE EXISTS in a loop. it is possible to create a @parentList varchar(max) variable and return result as a string '6,5,4,3,2,1' and split it on client-side, but that format is explained with an example, how to loop through table rows with Cursor in SQL Server. it only inserts the first record it then stops. satabeac SOLVED; User: satabeach; Posted: on Jan 30, 2018 01:03 AM; Forum: SQL Server; Answer: 1; Views: 34288; I want get records for each date between two dates in sql . Although I don't advocate this approach, to make your loop First of all, doing: select @serial = select serial from T1 while @serial Doesn't mean that it will start to magically loop for every value of serial that T1 has, it will just assign one value of serial to your variable (if it was correctly written anyway select @serial = serial from T1). Different ways to SQL delete duplicate rows from a SQL Table; SQL WHILE loop with simple examples; The Table Variable in SQL Server; Overview of SQL RANK functions; SELECT INTO TEMP TABLE statement in SQL Server; SQL Server functions for converting a String to a Date; How to identify and resolve SQL Server Index Fragmentation Hello everyone, In this article, I will tell you about the use of While loop in SQL Server. Already there is answer for DO while loop. We also SET the Number value to increment (@Number = Using while loop in stored procedure works correctly in SQL server but returns only first row to asp. The statements are executed repeatedly as long as the specified condition is true. That is, earlier than the loop would have ended if left to it's natural progression. Learn / Courses / Intermediate SQL Server. How to use a While Loop in where clause. How to update values in while loop. I ask because the WHILE loop seems clearer and easier to What I am trying for is to exit the loop when a condition meets (if not exists block) while printing the statement; else to continue with the while loop. It’s useful for iterative tasks and processing data in batches. In SQL Server, table names beginning with # are temporary tables and are created in tempdb. It is important to check and write while writing, 148 Views. Often times a recursive cte will not suffer the same performance penalty. Thanks for any guidance. The following illustrates the syntax of the explained with an example, how to use WHILE loop in SQL SELECT query without using Stored Procedure using Cursor in SQL Server. Here is an example of WHILE loops: . حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ HOME; BLOGS. I want to replace the number 100 in 'WHILE @i - 100 <= 0' by the value in Gun column Edit -The point is I want it to iterate over the same row N number of times where N equals the Gun value of that row, so duplicate the insert of each row N number of times I am using this stored procedure to implement a search functionality in tree view in which I want to keep the parent-child hierarchy after search. Adapt SQL query in a while loop. Modified 11 years, 4 months ago. table where StatusID = 7 OPEN @MyCursor FETCH NEXT FROM @MyCursor INTO @MyField WHILE @@FETCH_STATUS = 0 BEGIN /* YOUR ALGORITHM GOES HERE */ Avoiding while loop in SQL Server. – I am trying to loop a varchar in SQL Server, one of the columns has the format &quot;F1 100 F2 400 F3 600&quot; What I need is to take the numbers and divide by 10: &quot;F1 10 F2 40 F3 60&quot;, In Sql Server 2000 and 2005 I am running a select statement in a while loop. The following illustrates the typical syntax of the Grouping within a While Loop, SQL Server. . Display results from sql while loop in a single table. willie willie. Viewed 3k times Im having a hard time looping using sql, the table Im using resources references itself by having a parent column so I want to do the following logic while creating the view in sql but I'm stuck. SQL Server 2008 - Multiple Updates WIth Loop. user1849946. I am detailing answer on ways to achieve different types of loops in SQL server. asked Dec 26, 2012 at 3:19. Avoiding while loop in SQL Server. Using while loop in sql. FAST_FORWARD Specifies a FORWARD_ONLY, READ_ONLY cursor with performance optimizations enabled. While loop and select. sql; sql-server; Share. While loop in Microsoft SQL Server 2008. WHILE loops are a fundamental concept in T-SQL programming, allowing us to execute a block of code repeatedly as long as a specified condition is true. The execution of statements in the WHILE loop can be controlled from inside the loop with the BREAK and CON In this article we will look at examples of a SQL Server WHILE loop in T-SQL and discuss alternatives like a CTE and cursor. For j = 0 to 9: (Iterate through the column **Day**) y=0; Here is an example of WHILE loops: . ID = T. The Overflow Blog Variants of LoRA. Ask Question Asked 8 years, 4 months ago. How to do the while loop in SQL Server query. UNTIL version of SQL server. Follow edited Dec 26, 2012 at 3:22. ) How to use the looping in S A properly declared cursor will out perform a while loop like yours - Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR; The general consensus is that prefixing object names is not a good idea. When you need to loop a set of data, is there a benefit of using a SQL Server cursor. For instance, as I said prior, in a sequence of transactions or events, if any operation or action is subject to the previous one after being endured by the same in a sequence then we can While loops will be slow because that's what happens when you use procedural logic to develop in a declarative programming language. I get the syntax error: Incorrect syntax There is a good chance the CTE will be faster. I will try and improve it a bit after that. SQL Server 2008 insert into table using loop. However, if you have 2-3 levels of nesting at best, you might try using recursion or using CTE, which is also a bit recursive (SQL Server 2005 and up By using T-SQL and cursors like this : DECLARE @MyCursor CURSOR; DECLARE @MyField YourFieldDataType; BEGIN SET @MyCursor = CURSOR FOR select top 1000 YourField from dbo. 1 1 1 gold badge 1 1 silver badge 2 2 bronze badges. WHILE or REPEAT. In each iteration of the WHILE loop, some functions are called with dates variables passed as parameters. 75); -- View the initial data SELECT * FROM Orders; I want to change my SQL code which generates n table using two nested While loops, like: DECLARE @count1 INT SET @count1 = 2012 DECLARE @count2 INT SET @count2 = 1 WHILE @count1 <= 2016 BEGIN Skip to main content. 0. deserved = 1 For the table below, I need to perform a loop operation in SQL Server 2008: The column Day in the table can have values from 0 to 9. SQL Solve a In a SQL Server 2012 stored procedure, I have several nested structures. Modified 11 years, 5 months ago. The sample data is as follows: The DailyBookFile has 150k records for each date, from year 2010 (i. Tag the dbms you're using. SQL "Must declare the scalar variable" 0. Remember that SQL is set based, so select * From mytable will select every record in there. Internally it contains a form of while loop, but that loop sits deeply in the query execution pipeline. Using a cursor in a stored procedure to loop rows MySQL. Perhaps if you add AND Month(Period) = @Counter to the where clause there. I want to break out of a single layer of them. It is a control flow statement and it is used to perform iterations until the condition holds TRUE. I'm basically trying to caputure sql commands and their wait time for CPU, and I simply want to run a while loop for 60 seconds and insert all the data into a temp table. Since @Count = 1, and @Side1 is now 2, your WHILE predicate is no longer true, so the outer loop exits. Summary: in this tutorial, you will learn how to use the SQL Server CONTINUE statement to control the flow of the loop. How can I rewrite? Sample Query is in the below. SET NOCOUNT ON DECLARE @vendor_id int, @vendor_name nvarchar(50) DECLARE @subvendor_id int, @subvendor_name nvarchar(50) PRINT '----- Vendor Products Report -----' DECLARE vend_cursor CURSOR FOR SELECT * FROM MYSEQ OPEN vend_cursor FETCH NEXT FROM vend_cursor INTO @vendor_id, OK, this will get you the desired result, but it is questionable. The WHILE statement is a control-flow statement that allows you to execute a statement block repeatedly as long as a specified condition is TRUE. For example, I'm looking for something similar to the logic behind the below. Is it possible my code: ; with myCTE(a,b) ( select . WHILE loop in SQL. It seems to say a BREAK Summary: in this tutorial, you will learn how to use the SQL Server BREAK statement to immediately exit a WHILE loop. Our next phase—Q&A was just the beginning. why not use a loop in your business logic, not in your stored proc as much as possible I have an INSERT statement that operates within a WHILE loop. It should either be obvious from the context if an object is a table/view or function/procedure, or it should be irrelevant - i. We are using WHILE loop in SQL Server 2008 instead of Cursor. JFYI, this select statement is connecting to many linked servers and getting some values. If created in the body of a stored procedure, they are dropped when the stored procedure execution is terminated. try search for recursive cte in sql-server. 800 --> 08:00) with different amounts and a unique ID field. SQL Server has a small per-statement overhead (even if it is just select null). Let’s look at an example of using WHILE loops in SQL Server: To skip an iteration in your loop you use the CONTINUE keyword. This is a stripped down example: In my SQL-server database there is a table in which each day has many entries for each time value (in integer form e. WITH CTE AS ( SELECT DISTINCT ID, [NAME], ID AS PARENTID, ITEMTYPE, COST FROM TABLE1 UNION ALL SELECT T. Run a while loop for a fixed amount of time in SQL. CONTINUE Causes the WHILE loop to restart, ignoring any statements after the CONTINUE keyword. user1849946 user1849946. EmploymentTypeID FROM EmploymentTypes b INNER JOIN #ListEmployments l on b. My idea was to use a loop to select the relevant contracts. Using CTE with while loop in SQL server 2005. As soon as a variable declaration is encountered as each batch is being parsed, the variable name becomes valid from that point onwards until the I want to use CTE with while loop. Declare @TotRecord int, @CurrRecord Int, @id varchar(10) Select @TotRec = COUNT(*) from Table1 Set @CurrRec = 1 WHILE (@CurrRec <=@TotRec) BEGIN --*Here i want to get the id from table, --next time i need to get second id. This chapter explores how to create aggregations in SQL Server, a common first step in data exploration. Try with #temp table, because whenever that while loop running you are selecting a new SELECT statement, that is why it comes in a different window. You can do this by generating the date list with a tally table, and doing a JOIN to it on your INSERT:. Which really doesn't make sense. The CONTINUE statement stops the current iteration of the loop and starts the new one. SUM(CASE WHEN Navn = '000100' THEN Vaerdi ELSE 0 END) AS '000100', SUM(CASE WHEN Navn = '000110' THEN Vaerdi ELSE 0 END) AS '000110', SUM(CASE WHEN Navn = '000115' THEN Vaerdi ELSE 0 END) AS '000115', BREAK: BREAK is used with while loop to exit from the current WHILE loop with an condition. How to build a WHILE Loop using SQL Server 2014. To break a WHILE loop early, just use the BREAK keyword! Take EDIT: Actually, you need to move this loop: WHILE @Iteration <= @diff BEGIN SET @Iteration = @Iteration + 1 END to INSIDE your cursor, so that it executes for each of the rows in #diff_temp. Either use a union view like Xedni suggested or at the very least stop dropping the temp table inside the loop. It is much faster than a T-SQL loop. COST FROM CTE AS C INNER JOIN TABLE1 T ON C. This guide will walk you through the basics of nested WHILE loops in SQL Server, complete with simple examples and a demonstration of the BREAK statement. These date variables increase by one day at each iteration of the loop. Stack Overflow. We basically break a while loop when we want to terminate the loop early. DECLARE @startTime datetime2(0) = GETDATE(); -- This will loop until BREAK is called, or until a timeout of 45 seconds. Hot Network Questions How "alien" must an alien language be? Did the Trump administration explain why the US-Ukraine minerals deal does not include security guarantees? Predicting the number of disabled people in Canada What is the source of the common claim that 3. 4. First I'm just curious why you don't just do a normal update? update emp set salary = emp. ID SQL Server: Endless WHILE EXISTS loop. CREATE TABLE test (id INT IDENTITY(1,1), x VARCHAR(32)); GO BEGIN TRANSACTION; INSERT INTO test (x) I have two columns I want to output query like I try to use loop in SQL but I failed to output query My question is: how can I repeat the values in the [Name] column by the number in the [Total] In T-SQL, variable declarations do not participate in control flow. * FROM @info AS I INNER JOIN dbo. Also, it is a single statement. WHILE loop helps us to achieve iterative operations in SQL Server. How SQL While loop works in SQL Server Most metrics, which are being used in a SQL While loop is can be accomplished by a single statement, yet a few can’t. Related. If the current WHILE loop is nested inside another while loop, BREAK exits only the current loop, and control is given to the next statement in the outer loop. – TheMadDBA. since im using a left join between my auth_permissions table and resource table, we are always looking at a row of type 'table' - for the current row in table resources which is In addition to the WHILE 1 = 1 as the other answers suggest, I often add a "timeout" to my SQL "infintie" loops, as in the following example:. [DoorDetails] @emp varchar(16), @fr In the same batch (within the same transaction) you can simply issue a SELECT command to see the updated content of the table. from abc ) while exist (select * from mycet) -- causing issue Please suggest some solution. ,. SQL-Server and database servers in general are highly optimized query engines, but are not I want to rewrite the Recursive CTE to while loop in SQL Server. The issue is application queries which use this view is is running very slow. salary + (bonus * 2) from employee emp join bonuses bon on bon. it is used with if statement. Table A has Date, ISBN (for Book), Demand(demand for that date). Otherwise, it will exit from the iteration. Tags: SQL Server While TSQL While Using Select records between two dates using While loop in SQL Server. ID AS PARENTID, T. If you know, you need to complete first iteration of loop anyway, then you can try DO. The loop stops when the condition becomes false. willie. So, any deeply recursive logic will break. WHILE Boolean_expression BEGIN-- code I'm currently cleaning up a few queries in my SQL views. While loop in SQL Server is a construct that keeps a certain block in the loop by repeating. I'm using SQL Server 2005. How to run series of values through stored procedure. Or is using a WHILE loop (see below) just the same. Infinite WHILE LOOP with T-SQL. Commented Jul 7, 2015 at 18:05. While most users grasp its functionality quickly, a few might find it The WHILE loop is used to execute a block of code repeatedly while some condition is true. While Loop Issue. The article explains how to use the SQL While loop in Microsoft SQL Server to In this article, we learned the SQL WHILE loop with quite simple examples. We also virtualized and explained the examples with flowcharts. ifference between cursor and while loop in sql server with example or explain cursor vs while loop with example in sql server. This assumes that you want to do something that cannot be done in a set-based way. Ask Question Asked 11 years, 4 months ago. SQL Server BREAK statement overview. Sometimes when working with SQL Server, you need certain code to execute several times in a loop while some condition is true. This is an answer to the original question. 0 material which has not been Note: If you are using SQL Server you would be better served using: WHILE EXISTS(SELECT * FROM #Temp) It will be as fast as building up a while loop and much easier to maintain over the long haul. 8. FAST_FORWARD cannot be specified if SCROLL or FOR How to use While loop in SQL SERVER | SQL Training Sessions | SQLThis session will help you understand the following concept :1. What you're trying to accomplish is basically select all the data from mytable then union it again on the same setn times. Follow edited May 10, 2017 at 15:27. TSQL - WHILE LOOP. SQL Server Update Query Not Working. while loop select in SQL Server. DECLARE @tblCalendar TABLE( CalendarEntryID INT, Slot INT ) DECLARE @x int, @y int SET @X = 1 SET @y = 1 WHILE @X <= 100 BEGIN WHILE @Y <=8 AND @X <= 100--LOOP FOR SLOT COLUMN BEGIN INSERT INTO @tblCalendar (CalendarEntryID,Slot) Values In SQL Server: when you need to loop a set of data, is there a benefit of using a SQL Server cursor. The WHILE loop in SQL Server is a control-flow statement that allows us to repeatedly execute a block of code as long as a specified condition is true. Hot Network Questions Finding for duplicate active DHCP servers on local network I have used a table value function to perform this task using a query such as the following: SELECT I. Method 1 (Using BREAK Keyword): DECLARE @V_Counter INT = 1; WHILE (1 = 1) BEGIN PRINT @V_Counter; SET @V_Counter = @V_Counter + 1; IF @V_Counter = 4 BEGIN BREAK; END END Method 2 You can do this a number of ways. Now I want to find which method is best to write WHILE loop in my procedure. FROM MSDN: BREAK Causes an exit from the innermost WHILE loop. asked May 10, 2017 at 13:25. 2. ID, C. While loop also same as cursor to fetch set sql-server; while-loop; charindex; or ask your own question. The ‘WHILE’ loop is used in the stored procedure uspCounter; this is the same one you learned. Changes will be persisted when the COMMIT TRANSACTION statement is executed or reverted on ROLLBACK. Hot Network Questions A double problem on compact and connected EDIT: The question was drastically changed in the grace period. Improve this question. I ask because the WHILE loop seems clearer and easier to understand. Featured on Meta bigbird and Frog have joined us as Community Managers. Overview of WHILE statement. DO. Modified 8 years, 3 months ago. Table B has Date, ISBN (for Book), and SalesRank. Featured on Meta bigbird and Frog have joined us as Community Managers The while loop doesn't hold on to the selected set and know it the next time through. IF there is any error, i want it should still execute next statement in the In the next line, we used the SQL Server while loop condition. Table1 - Readonly Table (non editable) id name M01 Raja M02 Ravi M03 Vijay M04 suresh Query. asked Sep 18, 2013 at 17:51. I managed to get it to route the way I desired by adding a dummy WHILE loop around the inner IF I want to break out of first. I need the row count from the temp table to determine when the loop should finish. Example: Following sql exit the current loop when @count will when SELECT statement returns no rows then assignment of variable (@colname=colname) is not executed - and value of @colname remains unchanged - non-null, value from previous iteration - loop will continue forever i need help in understanding why is the loop below not working. Views: 484; SQL Server; Cursor; Download Code In this article I will explain with an example, how to loop through table Inside the WHILE loop, the processing is done for the current record and then again the next record is fetched and the records are Summary: in this tutorial, you will learn how to use the SQL Server WHILE statement to execute a statement block repeatedly based on a specified condition. 150k * 365 days * 8 years) rows. Introduction to the SQL Server CONTINUE statement. I know that it's not best practice to apply a while loop within SQL code, sql-server; while-loop; left-join; temp-tables; Share. SQL Server demands scalar variable declaration. sql; sql-server; while-loop; string-concatenation; or ask your own question. Only While Loop is officially supported by SQL server. You will also clean missing data and categorize data into bins with CASE statements. Recapping Stack’s first community-wide AMA (Ask Me Anything) Stacks Editor development and testing sql-server; t-sql; while-loop; Share. Complicated SQL while loop. I have to use a while loop only. SQL Insert Data to Temporary Table and Save the result as a View. declare @new_balance float , @cur_new_balance float , @old_balance float , @cur_old_balance float , @initial_balance float , @rate float , @monthly_rate float , @monthly_interest float , @payment float select @rate = interest from accounts where Another way to iterate over records in SQL is with a WHILE loop, especially when using increment-based iteration. WHILE Loop How to do the while loop in SQL Server query. How to use a While Loop in SQL to Create a Variable. If you want to repeatedly execute a particular SQL script, the SQL While loop is the way to go. 1. 00), ('Charlie Davis', '2024-07-24', 125. employee_id = emp. Any statements that appear after the END keyword, marking the end of the loop, are executed. employee_id where bon. Aaron Bertrand has written a great series on generating a set or sequence without loops: Generate a set or sequence without loops – part 1; Generate a set or sequence without loops – part 2; Generate a set or sequence without loops – part 3; I have 2 tables. 69 2 2 gold badges 2 2 silver badges 9 9 bronze badges. T-SQL dynamic sql within while explained with an example, how to use SQL WHILE LOOP through Table rows in SQL Server. EmploymentID PRINT 'Open cursor' OPEN cursor1 FETCH NEXT FROM cursor1 INTO @pEmploymentTypeID WHILE @@FETCH_STATUS = 0 Advanced SQL Tutorial | Looping in SQL Server | WHILE LoopsIn this training video, we walk through how to write a while loop in SQL in order to loop through SQL Server while loop seems to nest calls. Views: 539; SQL Server; Cursor; Download Code In this article I Sql server while loop. net grid view. All you have to do is to place the while loop within the BEGIN and END blocks of the stored procedure. WHILE (Select ContractType from Table2) = 'Student' Begin Select ContractStart from Table2 Order By ContractStart End Unfortunatley the loop is not working yet and if I do not know how to implement it into the where clause. Here's my code: PRINT 'Define cursor' DECLARE cursor1 CURSOR FOR SELECT b. Infinite While Loop T-SQL. To exit the current iteration of a loop, you use the BREAK statement. WHILE (GETDATE() < DATEADD(SECOND, 45, @startTime)) BEGIN -- Logic goes sql; sql-server; t-sql; while-loop; try-catch; Share. Convert multi-statement table valued function to inline TVF. Looping SQL statement insert. 1. In one view a number of columns are generated using the following syntax. Follow edited Sep 18, 2013 at 17:59. My stored procedure create procedure [dbo]. That code is product specific. 19 1 1 silver badge 5 5 bronze badges. ITEMTYPE, T. SQL Server while loop and dynamic SQL. TSQL not causing infinite loop. SQL Server loop and insert in sql. e. g. Ask Question Asked 8 years, 3 months ago. The following illustrates the syntax of the CONTINUE statement:. I am investigating this and i found out a Using local function parameter inside a while loop - SQL Server. In the previous tutorial, you have learned how to use the WHILE statement to create a loop. I'm trying to create a procedure in SQL Server 2008 that inserts data from a temp table into an already existing table. While loop issues. As soon as that condition is false, you want the loop to stop executing. Understanding The WHILE loop in SQL Server is straightforward to understand and widely used for iterative operations. But I'd really like to know how I'm misinterpreting the msdn info. I'm using sql server 2008. SQL While Loop exists. ghastie55 ghastie55. I've been asked to produce a dataset using a view in SQL and have a number of products (eg 'a a','b b','c c') and I want to work out totals over 5 years (1,2,3,4,5) and output the totals as total_a Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse An Sets a condition for the repeated execution of an SQL statement or statement block. EmploymentID = l. It’s useful for This tutorial shows you how to use the SQL Server WHILE statement to execute a statement block repeatedly based on a specified condition. Using a WHILE Loop in SQL Server. What you want doesn't really make sense to do it in a loop; sql works in sets, and you should The task of breaking a WHILE loop in Microsoft SQL Server is very simple. 3. SELECT column A, column B WHILE (@CurrentYr <= @MaxYr) BEGIN ,CASE WHEN(Year = @CurrentYr THEN, columnC) SET @CurrentYr = @CurrentYr + 1 END FROM Table1 A while loop is always going to suffer from a performance standpoint. Declare @FromDate Date = '2015-01-01', @ToDate Date = '2015-01-31' ;With E1(N) I have this query in SQL Server and I have a table Rezotel with column name Gun int type. DECLARE @StartDate DATETIME = '2018-08-01'; DECLARE @EndDate DATETIME = '2018-08-15'; CREATE TABLE #Temp ( Date date ) The WHILE loop is one of the most basic tools you should know when you are first starting out with Microsoft SQL Server. They are local to the session and exist for the duration of the session. View Chapter Details. The while loop runs many statements. If the condition result is true, the number is added to the total. Scalar function with WHILE loop to inline function. First of all, as someone said in the statements, recursive stored procs, while possible, are not a good idea in SQL Server because of the stack size. I want get sales for each day between two dates (2018-01-01 to 2018-01-31) (From_Date DATE,Product_Id . Nested WHILE loops take this concept further by placing one WHILE loop inside another, enabling more complex iterations. I think I've pretty much figured it out, I'm just having an issue with a loop. Cursors in sql server allow you to fetch a set of data, loop through each record, and modify the values as necessary; then, you can easily assign these values to variables and perform processing on these values. Ask Question Asked 11 years, 5 months ago. I'm not very good while cursors, or how to accomplish this one in sql. SQL Update in While Loop. The loop continues to run until this condition is False. ghastie55. Although to actually answer your question, your loop exits after one iteration because you have this condition: WHILE (@side1 = @count) After the first iteration of @side2 1 - 10, you do SET @side1 = @side1 + 1;. osurpr kiyw edxhr qkb sjobn qos kjmgwcy jzqp jzbsz ssqscy imjykzj pyve vaaq dcxu cxe