Wael (sedky@rocketmail.com) writes:
> Thanks for your response. My ultimate goal is to return all the rows
> not just one. Is that doable?

Yes, that's a very normal thing to do.

> Also even with the select statement, the results are not accessible to
> ADO.Net even though I can see them in the query analyzer.

So how does your ADO .Net code look like?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx