We're using nintex workflow for SharePoint 2013. I'm trying to return all the results in a SQL Do..While..Select statement and incrementing an integer in that statement.
in this case in sql management server studio it would return multiple result sets. my question is there a way to return all those result sets into one using the single statement? From what it looks like it only returns the first set of values Or would I have to break down the query and do a for each or loop on the execute sql while using a workflow variable to auto increment the integer?