Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

Using Break in a nexted Query

Hi all
I have a while loop in a nexted query

1: Query do some proccessing.. Control checks
2: If the check is okay.. Get values..
3: Insert values until I have reach the maximum (Since I have break here.. My code stops)
4: clean up isolated transaction and write a report.

How can I continue to step 4, given that I am using the while loop  on step 3.

Thanks in Advance..

Sorry I am not a native speaker  :-)
0
ZURINET
Asked:
ZURINET
  • 2
  • 2
1 Solution
 
David ToddSenior DBACommented:
Hi,

Are steps 1 - 4 in the loop, or just step 3?

Any chance of posting the code - its just that there are a number of different ways to test for the end of loop or continue in loop conditions, and without seeing your code I'm more likely to be wrong than right.

Regards
  David
0
 
ZURINETAuthor Commented:
sorry 
just solved it

 WHILE (@Flag < @counterCheck)
	 BEGIN								 
	
	-- SQL STATEMENT				
	SET @Flag		= @Flag	+ 1
	SET @PositionNr	= @PositionNr + 1								
	END		

Open in new window

0
 
David ToddSenior DBACommented:
Hi,

That's cool that you've solved it!

Regards
  David
0
 
ZURINETAuthor Commented:
Just solved it
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now