how to use loop to get my sql server data

(0) Share

Report

Posted on by JACK_LAI_1117

267

HI everyone:

In sql server database , I have a table to record all my employee data , like I use employeeID can check his manager_id .

Now , I have to his first manager , second manager , third manage .......etc( some user maybe has 3 level , but some user maybe has 5 level , it will depend on real situation ) .

So can I use do....until or other method to data what I need

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JACK_LAI_1117

Can you share the format in which the data of the managers will be returned? You can use the Apply to Each control to loop over each individual record.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JACK_LAI_1117 ,

I suggest that you could share the example of the table column and data, and explain more details about the requirement so we could better understand you and provide the workaround.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Verified answer

JACK_LAI_1117 267 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-alzhan-msft

@yashag2255

Finally , I use a stupid method to overcome my problem .
I ran sql query ten time , every-time the result I put the value to test-array ,then I remove null value in test-array .

Now on , I can use test-array to finish my job ~~~~

Thank you very much !
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JACK_LAI_1117 ,

Glad that the problem is solved.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.