Loop Result Set Sql. In Oracle there was this cursor that allowed me to loop through the results of a select statement but I cant figure out how to do it here and also not to return that result set. I am not sure how to do this though.
In the control flow of an SSIS package add an Execute SQL Task and open the editor. Append the order by clause to a select query execute it and return the result set. Can I UNION all.
If the result of the condition is true the SQL statement will be executed.
Ask Question Asked 6 years 6 months ago. DECLARE db_names CURSOR FOR select name from sys. In Oracle there was this cursor that allowed me to loop through the results of a select statement but I cant figure out how to do it here and also not to return that result set. I am not sure how to do this though.