SQL with Call and for-each

Hi All,

I have a sql call that returns more that one record and for each record I must transform the data into an xml format and send it to a .NET call. I succeeded in a single line on a real time trigger from SAP B1. But the sql call has multiple records. please help.

I get the following error:

Please help, Brenden Draper