How do you return a ResultSet from a SQL Server stored procedure with multiple parameters? I understand you can use the Table Input step but I am unsure of the syntax to execute the stored procedure with more than 1 parameter. <a data-tag-text="Kettle" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Kettle%22&executesearch=true" data-tag-key="e58f5353-0c00-4c3e-854c-4b082a5ea7b6">#Kettle</a> <a data-tag-text="Pentaho" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Pentaho%22&executesearch=true" data-tag-key="70b4436b-4549-4ce3-aa64-4566c7b665c9">#Pentaho</a> <a data-tag-text="PentahoDataIntegrationPDI" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Pentaho Data Integration PDI%22&executesearch=true" data-tag-key="b01e3d75-3411-4f9a-a674-a7e8d0c9c995">#PentahoDataIntegrationPDI</a>

Pentaho

View Only

Rob Burgess posted 05-17-2018 18:56

How do you return a ResultSet from a SQL Server stored procedure with multiple parameters?

I understand you can use the Table Input step but I am unsure of the syntax to execute the stored procedure with more than 1 parameter.

Lucas Goncalez posted 05-17-2018 19:16

Hi Rob!

In my case, i create a temp table in my stored procedure.

So i run SP in the normal way and after i make a select in the temp table.

pastedimage_0

I believe that to use parameters would be in the conventional way:

pastedimage_1

I hope it helps.

Rob Burgess posted 05-17-2018 20:44

Thanks Lucas.

I will try this.