Well of course the partnership between Dell and EMC is relatively new, so I would instantly ask who will be supplying maintenance contracts etc. That aside, the next subject...

Hi

Remove this from your SELECT:

'[Amount] = ' - you don't need to name columns in a SELECT which is part of an INSERT.

Regards

Simon

Actually answered my own question (868 rows), sorry. Why are you using FAST FORWARD and not READ ONLY as the cursor type?

I'm not going to answer your question directly, but I will say a few things. Firstly, you're use of a NOT IN will not take advantage of any indexes...

The answer is unfortunately not as clearcut as that. Many times I have seen performance drop significantly between writing something on my single processor development system, take it to...

I'm not 100% certain that this is the correct approach. You really should be using optimistic locking, and then testing to see if the row has been changed when...

You could well find that having a permanently defined table to hold the working data set will be far faster because you can put indexes on it.

Variable of table type...

Which is worse? I suggest that the use of the temporary table, which is being created with a SELECT INTO with all of it's inherent problems with locking, is...

Simon

I did ask you before how you would therefore code a routine where something has to be done to each of a set of rows from a query, say for...

The thing you must watch out for is that the fabric between the server and the SAN, especially in the case of fibre channel. I've got a fibre optic...

I think rather than looking at the semantics of the database design, you should consider how the business wants to use the data and what it's plans are going forward....

OK Simon, then how do you code things like loops of rows in a cursor where you need an action to occur on each row, rather than an aggregated result:...

Well I think that about sums it up, lol - hope you're paying attention at the back - there will be questions at the end...

Yes Simon, I would add though for swjs benefit that the test on @@rowcount should be inserted immediately after the SELECT else the result cannot be guaranteed to be relevant.

Rgds,...

The reason is that you need to cover the eventuality that your <some condition> is going to fail sometimes. If you don't reset the value or use ISNULL() to...