Need help in iterating one loop inside another while loop in sql procedure

Question

Need help in iterating one loop inside another while loop in sql procedure

Mohammed Muntazim 21

ALTER PROCEDURE [cmn].[InsertXMLOutputConfig]
(

@P_DataSubject NVARCHAR(5),
@P_DRS NVARCHAR(10),
)
//i need help in iterating one while loop inside another while loop
//@P_DataSubject value is support 'as,ds,re,tr'
//@P_DRS value is suppose 'hrr,yte,ytw'
//@P_DataSubject i want to put in parent while loop and @P_DRS in child while loop

Olaf Helper 47,436 Reputation points

2022-10-26T08:39:24.287+00:00

Your post is very unclear and in common one rarely us iterations in SQL, we use set-based solutions.
So please provide more details about what you have and your requirements.
Ronen Ariely 15,206 Reputation points

2022-10-27T20:29:09.853+00:00

Hi,

Please provide a full example so the stories will be more clear and we will be able to discuss specific scenario which we all can test practically

We need you to provide

1) Queries to CREATE your table(s)
2) Queries to INSERT sample data.
3) The desired result given the sample, as text or image of excel for example.
4) A short description of the business rules, and how you got 1-2 of the results
5) Which version of SQL Server you are using (this will help to fit the query to your version).

3 answers

Your answer

Olaf Helper 47,436 Reputation points

2022-10-26T08:39:24.287+00:00

Your post is very unclear and in common one rarely us iterations in SQL, we use set-based solutions.
So please provide more details about what you have and your requirements.
Ronen Ariely 15,206 Reputation points

2022-10-27T20:29:09.853+00:00

Hi,

Please provide a full example so the stories will be more clear and we will be able to discuss specific scenario which we all can test practically

We need you to provide

1) Queries to CREATE your table(s)
2) Queries to INSERT sample data.
3) The desired result given the sample, as text or image of excel for example.
4) A short description of the business rules, and how you got 1-2 of the results
5) Which version of SQL Server you are using (this will help to fit the query to your version).

Answer 1

Sreeju Nair 12,666

Are you looking for guidence in implementing nested loop, I mean a loop inside another. If yes, refer the following tutorial.

https://www.tutorialgateway.org/nested-sql-while-loop/

Hope this helps

Mohammed Muntazim 21 Reputation points

2022-10-26T08:48:21.23+00:00

i need to iterate both input values in nested while loop and split the comma( ,) separated value.
example : @P_DataSubject value i am providing 'as,re,tf,yt' i need to split comma separated value and i want to iterate value like as re tf and yt
like that @P_DRS value im providing 'asa,trd,ytr' ,i need comma separated value that is asa trd and ytr.

Answer 2

Jingyang Li 5,896 Volunteer Moderator

You may be able to write your nested loops to solve your problem but it is not the right way to do so.
Think about your issue with nested loops in pseudo-code and implement a SET-based solution in your stored procedure.
If you need more assistance, you can provide more information and sample data and expected result.

Answer 3

Tom Phillips 17,771

You normally do not want to "loop" in SQL Server.

Can you explain more about what exactly your proc is expected to do?

Share via

Need help in iterating one loop inside another while loop in sql procedure

3 answers

Your answer