Skip to main content
Question

How to properly retrieve multiple-tables results of a sqlserver stored procedure ?

  • January 11, 2017
  • 0 replies
  • 26 views
V
Forum|alt.badge.img

Hi !

 

I run a stored proc. from sqlserver whose results consists of roughly 10 "tables"/"datasets". (some of them might be empty for certain values of the exec parameters)

 

When called several time with different parameters from a SQLExecutor, the result is a stack of every line of result from every table for every iteration of the call...

 

 

I want to call a python script for each iteration of the call, that will do different things with each dataset of the result...

 

how to split the lines of the result back through each iteration of the call and each dataset ? (And How to know which tables of the results where empty ?)

 

Any way to get the cursor metadata in attributes (ex : the dataset index in the result cursor)?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.