Re: Suggest me best way

One solution might be that rather than calling the Sql server from your orchestration directly,  you do this in a .net component, Get all the results in a DataSet, return it to your orchestration, and then use it for building up the final message.

Regards,

Sajid.