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 andrewg@intellinet.com

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?

 

Thanks!

Outcomes