locked
multiple select in stored proc handle in BizTalk RRS feed

  • 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

    Friday, September 4, 2020 2:32 AM

All replies

  • What have you tried?

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

    Friday, September 4, 2020 3:52 AM
  • 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

    Friday, September 4, 2020 4:23 AM
  • 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.. ?
    Saturday, September 5, 2020 8:24 PM