Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by demar
-
very strange problem with nested cursors
The first response sounds like it might be correct, but one of the SQL Server books in my library, Special Edition Using Microsoft SQL Server 7.0 (QUE, 1999), gives an example of nested cursors on page 630 that uses a "WHILE @@fetch_status = 0" for each...- demar
- Post #4
- Forum: Microsoft SQL Server: Programming
-
very strange problem with nested cursors
I am using a sproc to query 2 tables and input data into a new table for use in a ColdFusion file. I use a cursor to select each row of a table (Issues) and another cursor to select all rows of another table (comments) that match the first cursor's item number, ordered by...- demar
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
