How get data from SQL complex query and use it in endpoint

[. . 30]

I created an Integration event solution, then create a request/reply map, I want to get the result of a complex query and use it from an endpoint.

When I tried to set it in a stored procedure I can't get its data as a table result, Also I Can't use a sql function in request/reply map.

[Marty Smith 2]

You can't directly process a result set returned by a stored procedure in the body of the map 

You would need to have the sproc write the results to a table and then use a Fetch block to read from the table an process the data accordingly