Results 1 to 2 of 2

Thread: Cursors:

  1. 07-20-2003, 01:10 PM #1
    ndba
    ndba is offline Registered User
    Join Date
    Sep 2002
    Posts
    78

    Cursors:

    Hi:
    Basically I don't know of any other way to this without using cursor. I have to take 2 values from a single record from the outer cursor and pass it to the other stored proc which will give me a recordset that can have more that 1 records and I need to update each of those records. This is a nightly process.

    Could you explain how I can use temp tables for this kind of operation ?

    Thanks
    Reply With Quote Reply With Quote
  2. 07-20-2003, 01:24 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Could you provide a working example with sample table data.

    r u on SQL Server?

    you can also use function. let me know
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules