Dear SQLers:

I have been digging into cursors. It appears that one can not
modify a cursor variable passed as a parameter. Being able to do so
would be very useful. What do you do when you need to modify a cursor
parameter? Or what is the workaround?

Sincerely,

Gene Wirchenko

On Fri, 06 May 2011 15:00:39 -0700, Gene Wirchenko <genew (AT) ocis (DOT) net>
wrote:

Whoops! Read as "table".

What do you do when you want to treat a cursor as a table?

I want to build a cursor of data manipulating it with SQL
commands as I would a table and then update another table using the
cursor as a cursor.

Sincerely,

Gene Wirchenko

Gene Wirchenko (genew (AT) ocis (DOT) net) writes:
For your original question, I was about to answer that I don't use cursor
variables or parameters.

The fact that table-valued parameters are READONLY only makes them half as
useful as they could have been. Or maybe only 30% as useful. I have an
article on my web site that discusses a number of workarounds:
http://www.sommarskog.se/share_data.html-

I'm not sure that I understand your actual question, though. What do
you mean with "treat a cursor as a table"?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx