Jerry,
Its not often we get Shakespearean language on here!!! (“even though the procedure was called thrice“)
I think you need to provide the SQL that you are executing for us to be able to help further as you appear to have the BizTalk bits working (i.e. you are sending a request message and are receiving a response, only the response is incorrect).
Also, you state that multiple customer Id’s are sent in the request file, but later say that you call the procedure three times – can you clarify how the request is being made and send a copy of the Xml request message so we can see how the Stored Proc is being called.
Cheers, Nick.