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  SQL Server Development (2000)  opening a cursor with a @var

Author  Topic  Mark Starting Member 48 Posts Posted - 2001-01-31 : 11:08:23 Storedprocedure gets input from an asp page into a variable called @sql @sql = 'select (coloumns based on input into asp) from (table based on asp) where (input through asp)' declare emailcur cursor for (select statement would be here...) for read only open emailcur Can I use this variable for the select statment? if so what is the syntax?