How to populate and then then query a staging table in a Business Service

Solapas principales

Hi,

Newbie Question.

I have a Staging table i want to populate by running a Stored Procedure  and then query the same table with some sort of SQL inbound Adapter.

is this possible or do i need to create a separate service for this? 

 

Thanks