Steer clear of mapped drives in this case. Just because you see drives mapped when YOU log in, doesn't mean that the service account will. Use UNC notation...

At the hospital I worked at episode number = a serial number assigned by patient stay. Each time they left, or if they got transferred from outpatient to inpat...

Put an episode number on the form, and throw all of the other identifiable info away. You have access to the episode number lookup table, but no one else...

well - once I started being able to buy 300GB SCSI drives out of petty cash, I suppose the "buck" part stopped being much of a factor...:cool: Our equipment...

The only way to "emulate" what you seem to be getting at would be to wrap the two independent updates into a single transaction, so that if one fails, they...

It's a bit confusing to get at, but my understanding (based on graduation from the old school of hard knocks) of how it works is that it will use the...

Kenneth - you're right, I should have qualified. It's just that the OP seemed to be asking for "most performance bang for their buck", which is a situation where...

What are you expecting to error? Or rather - what is the error condition you're expecting to capture?

Although not necessarily the prettiest code ever - it doesn't look to...

Having SSMS installed doesn't mean you're running SQL server Express. Are you connecting to the correct database server instance? Remember - you can use SSMS against 2000 databases...

The points number under your name is posts+QOTD answers. The only place...

Well the only thing I can suggest is - if you have the option to test - throw it out there with a decent plan on how to rollback to...

well - it's not murderously bad with only 60 records, but 60,000 will cause your DB some nasty fits, and 6 million records...well you could go get lunch and then...

Nothing you've posted so far justifies using a cursor. Looks to me that you need to update the temporary table with the gridkey value, and then run an insert...

What indexes do you have going on each table? You'd need several compound indexes to make this work best?

Yelling at a messageboard community is not likely to get you answers. At best we might provide some area to look at. If you need more/faster - I'd...