We use Sequelize with MS SQL to retrieve data by executing stored procedures. The stored procedure runs as a RAW request.
Example:
EXEC spGetSummaryData;
The problem occurs when the spGetSummaryData procedure returns 2 result sets as a result of execution, but the result sets are combined into a single array.
sequelize.query("EXEC spGetSummaryData;", { type: sequelize.QueryTypes.RAW}) .then(function(summary) {
How to get arrays of results divided into two different arrays than one?
source share