How to Utilize Multiple Table Returns from a Stored Procedure?
In Bold BI, retrieving multiple data sets from a single stored procedure is not supported. By default, only the first result set is returned, and it is not feasible to join/merge multiple tables retrieved simultaneously.
Handling Multiple Result Sets
If there is a need to dynamically switch between stored procedure result sets that share the same metadata, you can achieve this by creating a parameter within your stored procedure. This parameter can then be passed dynamically through Bold BI parameters to switch between the different result sets.
When Metadata Differs
In cases where the metadata for the result sets differs, it is necessary to create separate stored procedures for each result set. This ensures that each procedure can be called independently, allowing for the correct handling of the data.
Summary
- Bold BI does not support retrieving multiple data sets from a single stored procedure.
- Only the first result set is returned by default.
- Use parameters in stored procedures to switch between result sets with the same metadata.
- Create separate stored procedures for result sets with differing metadata.
Additional References
