How to capture MSSQL SP output / multiple select statement results?

["Ankit Mathur" <ankitmathur82@xxxxxxxxxxx>]

Hi All,

 

I'm facing a problem I'm unable to find a solution for.

 

I hope fellow members would be able to help me out.

 

System Info: 

PHP v5

MSSQL 2008

Linux box

 

Ok lets say I have a stored procedure called proc_getData which has 2 select
statements....

Create Proc proc_getdata

AS

      Select COUNT(*) From Usr_Accounts;

      select top 1 * from Usr_Accounts;

 

then within my PHP script I called the procedure.. EXEC proc_getData();

How would it be possible to set each select statement from the procedure
into different results? so I could loop through each as and when needed on
my page? 

 

 

Or,

 

 

Second way is that I have a SP with  a single select statement but with an
OUTPUT parameter.

 

How do I capture the OUTPUT parameter while work with the result set of
select statement also.

 

Create Proc proc_getdata1 @cnt int OUTPUT

AS

      SELECT @cnt = COUNT(*) FROM Usr_Accounts; PRINT @cnt

      Select top 1 * From Usr_Accounts;

 

SQL Statement being executed: 

DECLARE @cnt INT SET @cnt = 0

Exec proc_getdata1 @cnt OUTPUT

SELECT @cnt

 

 

I want to capture my count variable @cnt to do paging while displaying the
Select statement result set on the web page.

 

 

Thanks and expecting a good response to my question



[Non-text portions of this message have been removed]