Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan of table
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01312331
Message ID:
01312349
Views:
20
>Hi Sergey, I'm all ears if you want to tell me how to avoid using a cursor, what the SP in question does is, inserts records into several tables used as audit trails for a given customer ref, populates fields clearing flags etc... on a per customer basis, at present the SP is used by an app which only passes it one reference to work with , I just thought as the SP is well proven I could use it in a batch operation

It seems like cursor is appropriate option in this case unless stored procedure can be easily modified to handle one or multiple custiomers based on parameters passed.
See DECLARE CURSOR in BOL for sample code.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform