Is this a theoretical question or is there a particular concern about a specific cursor that is troubling you? If you want our help, please provide specifics - preferably...

Mark - a couple of thoughts.

1. If you have Enterprise Edition, then that's the 'cadillac' full featured version of SS 2k5. But if it's truly full featured, then...

Paul - also, can you give us some detail about what version SS 2k5 you're using, and some information about your platform - op sys, processors, etc.

1. There are other threads on the forums here that discuss similar issues to what you have posted.

2. What kind of backups are you taking to protect your databases? ...

As a novice, you already have one foot dangling over the precipice! Building 'on the fly' systems is extremely complex and certainly not for the faint of heart. ...

a former au pair in my neighborhood used to say 'Peace, love and vegetables'. But she was Finnish, not US resident, over here for one year.

Let's see if I have this right:

Goals:

1. Correct calculation of: a. Inventory on hand, b. short term value fulfilled, and c. long term value fulfilled

2....

IF you are only using one table, then why don't you specify 'SELECT TOP 1 PERCENT CLAIMLIN.[ajdusr].... ?

Why use a temporary table?

Or, if you are trying to specify a 'random'...

At first blush, it would seem that the database is not normalized. If it were, you would not need to store non-key fields in two tables. That's the...

Would it be possible and feasible to insert extra columns (with NULLs allowed) into the 'local' tables? If so, then you can simply copy the content over, using the...

One other thought about your table example - given the nature of the content, just how big is this table going to be? Other than the non-indexed column, you've...

Chaitra - please understand that, from your perspective, what you've presented is the core of the problem that you are currently trying to solve. But that problem resides in...

IF you can guarantee that records are NEVER removed from the table you are indexing on, and IF you can guarantee that the index was built with the table originally,...

image did not make it across. what is the error message?

as posted in other questions, this question lends itself to a subsidiary CASE statement, where you control the logic based on the count of the records selected according to your...