This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 21%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
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
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.
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).
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
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
You normally do not want to "loop" in SQL Server.
Can you explain more about what exactly your proc is expected to do?