Hello Stranger,
Could you please provide more information. What is your stored procedure code like that is being called by the BizTalk SQL Adapter ? Are you trying to return multiple rows set of data or a single row of data, have you specified that the data being returned is in xml within the stored procedure? If you are trying to return multiple rows of data then it has to be catered for in your orchestration. This is my suspicion obviously it’s only a hutch because I need more information.