multiple select in stored proc handle in BizTalk

Question

I have 2 simple Select statements in a stored procedure. How to handle this in BizTalk
Please advise

ALTER PROCEDURE [dbo].[usp_Test_Select](
       
      @Poll int=1)
  AS
  
     Select  [Name],[City],[State],[Country] FROM [TEST].[Ins_db] Where [ID] between @Poll*(2) and @Poll*20
	 
	 select count(*) from [TEST].[Ins_db]


GO

---

RH

Answer 1

What have you tried?

Have you tried generating a schema from the stored procedure?  There shouldn't be an issue

Answer 2

It is working with 1 select statement, but back to back 2 select statements its not working.

Do you have any link that I can follow ? can you share ?

---

RH

Answer 3

What do you mean not working?

If you generate the schema of the stored procedure that has multiple selects, you should get a matching schema.  Are you using the Add Generated Item, Consume Adapter Service, sqlBinding, configure your Server, Instance & DB etc.. ?