Passing multiple values

[Tahir]

Is there some way to pass multiple values (records) to a stored procedure
without saving them first in a temp. table?

Can we use an API cursor to solve this problem?

Tahir

[Michael]

SQL Server does have a cursor datatype for passing cursors to stored procedures
but I've never tried it.

I believe the most common approach is to populate a temp. table.

-Mike