Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL 2000 Table Variables

Author  Topic 

catparks
Starting Member

18 Posts

Posted - 2001-10-31 : 14:39:13
I am using a table variable (as opposed to a temporary table) in a stored procedure. I am calling a cursor from within the proc and it updates the table variable. My problem is that I am being prompted to declare the table variable within the cursor - but I don't want to because it has already been declared within the main proc. Any suggestions?

Thanks,
CP

   

- Advertisement -