AnsweredAssumed Answered

Execute SQL - Return results from a Do While Statement

Question asked by tommytong on Mar 3, 2015
Latest reply on Mar 5, 2015 by

Hi all,


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?