I have verified that the procedure does return multiple ro
The problem is that my sql procedure returns only one row, but from asp side I can only get one:

```
ALTER PROCEDURE cphsdbm.tp_Trip_List
@UserID int,
@Trip_Name varchar(50) output
AS
BEGIN
SELECT @Trip_Name = Trip_Name FROM tbl_Trip WHERE UserID=@UserID; 
END

```

My code:

```
do
{
while (rdr2.Read())
{
trip_count++;
Response.Write("Success!");
}
trip_count++;
} while (rdr2.NextResult());

```