Forum Discussion
Run stored procedure in a loop
I get some data from a table, let say salesorders. Each salesorder has a few orderlines, to get the details from the orderlines I need to run a stored procedure for each line. I know how to run th...
Thanks, I also found this solution https://www.youtube.com/watch?v=iiNDq2VrZPY
In my case this is a better solution. However I notice something strange. Looks like the data which is in all the "data tables" is not loaded. Seems like I first need to open a table before the data gets loaded. Still try to figure this out.
Thanks, I also found this solution https://www.youtube.com/watch?v=iiNDq2VrZPY
In my case this is a better solution. However I notice something strange. Looks like the data which is in all the "data tables" is not loaded. Seems like I first need to open a table before the data gets loaded. Still try to figure this out.
Got it, I forgot to select the columns from the Stored pocedure (as explained in the video).