Can anyone give me a hand improving the performance of this cursor logic from SQL 2000. It runs great in SQl2005 and SQL2008, but takes at least 20 minutes to run in SQL 2000. BTW, I would never choos
Any body know how to use Datastore Cursors with JP开发者_C百科A?Can you try this (adapted from the JDO sample):
I have a table with about 1 billion rows. I\'m开发者_如何学运维 the sole user so there\'s no contention on locks, etc.
I\'m building a race administration system, with drivers and race heats. I need to divide, lets say, 13 dri开发者_StackOverflow社区vers into groups of maximum 6 per group. It\'s not possible since th
Here is the procedure I wrote- Cursors c1 & c2. c2 is inside c1, I tried declaring c2 below c1 (outside the c1 cursor) but then I is NOT taking the updated value :( Any suggestions to make it work
I have limited knowledge of SQL so can someone let me know if my thoughts are correct. I have a table that slowly fills up over time. I need to delete records from the first record to a given point in
Quick question about cursors (in particular Oracle cursors). Let\'s say I have a table called \"my_table\" which has two columns, an ID and a name.There are millions of rows, but the name column is
I have a cursor that is used to get some preliminary information for some other processing. It is possible that the query backing the cursor may not return any rows, and in these rare cases, we want t