http://www.mssqltips.com/tip.asp?tip=1495

Hello,

Related to this code:

Thank you very much

There are a few ways.  Below is one approach.

 CREATE PROCEDURE dbo.uspGetContact
AS
SET NOCOUNT ON

SELECT ContactID, FirstName, LastName
FROM Person.Contact

return @@rowcount
go

declare @rows int
exec @rows = dbo.uspGetContact
select @rows

Hello,

Thank you for your reply. 

However, maybe I wasn't clear enough, after calling the stored procedure I  need the actual selected rows, not the number of selected rows.

I'm afraid is not possible without an OUTPUT parameter returning the selected rows in a cursor.

 Your language of choice does not have a ResultSet type object?

In T-SQL, you can create a temp table/table variable to capture outputted rows.

Hello

>In T-SQL, you can create a temp table/table variable to capture outputted rows.

Please see the example below:

USE [Northwind]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE SelectCustomers
AS
BEGIN  
   SELECT * FROM Customers
END
GO

EXEC [SelectCustomers]

How can I access here in Transact-SQL, the rows returned by the  SelectCustomers stored procedure ? 

 You create a temp table

CREATE PROCEDURE SelectCustomers
AS
BEGIN  
   SELECT * FROM Customers
END
GO

create table mytable(column_list....)

insert into mytable(column_list....)
EXEC [SelectCustomers]