How ?

Hi,
How can i pass recordset as parameter in a SP Return value as a RecordSet ?u need not specify a parameter to retun a resultset. SP returns a resultset
if u query on a table in the SP
eg:
create Procedure retResultset
AS
SELECT * FROM <TABLE>
GO
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"DMP" wrote:

> Hi,
> How can i pass recordset as parameter in a SP Return value as a RecordSet
?
>
>|||Hi
No. SQL Server does not care about recordsets.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"DMP" wrote:

> Hi,
> How can i pass recordset as parameter in a SP Return value as a RecordSet
?
>
>|||About the best you could do is store the rows in a table with a key, and
pass the key to the SP, who then looks up the rows and does whatever...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DMP" <debdulal.mahapatra@.fi-tek.co.in> wrote in message
news:OOkXkaNZFHA.612@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can i pass recordset as parameter in a SP Return value as a RecordSet
> ?
>