[dba-SQLServer] Where does the data go

There are no recordsets in SQL, John. There are cursors but in general they
are despised by most experienced SQL programmers.

It is also not clear why you would want to pass the fields off to another
sproc. I would guess that you intend to call the second sproc once per field
in the recordset, but in that case why the second sproc? Why not just fold
that logic into the first sproc?

An explanation of what you are trying to accomplish would help me help you.

Oh, was the table-values dictionary stuff any help?

A.

On 12/7/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> As I mentioned last night, I need to iterate a recordset in a stored proc
> in
> SQL, sending the fields in the recordset off to another stored procedure.
>
> Is this possible?  I have my books out and am Googling like mad but I am
> not
> seeing anything like recordset objects in tsql.  I could switch to VB.Net
> and do it there but given that I am already in stored procedure mode
> (which
> I do not do a lot of, but need to get conversant in) I thought I would try
> and do it there.
>
> So is this possible at all in TSQL?
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>