Why on earth are you updating 70% of a million row table that is being accessed by users on a regular basis?   That's borderline insanity on the part of whoever...

p.s.  Deadlocks are so important, that the DBA(s) should monitor them daily and report on them weekly.  They should also assist in trying to figure out where the heck they...

Deadlocks are one of the most important but most people seem to have no clue about it and it doesn't turn on automatically...

Lookup "deadlocks, troubleshooting" for more on deadlocks and...

Remove the commas....

declare @dbname varchar(8000)

declare @countyname varchar (200)

declare...

Not sure why you think the statement terminates...

Care to share the details?

Vandy,

As Carl pointed out, you cannot use SET or IF.  A view must consist of only 1 SELECT statement or the UNION of several SELECTs (don't believe that will be...

In your last query posting, you are grouping by WRNotes and you cannot.

Now... that's why I was asking... you're doing it the hard way

If you have a SAN storage unit (or similar), check with...

p.s. Almost forgot... (pardon the soapbox, please) if you get into the habit of writing setbased code that will handle more than 1 row at a time, you've also solved...

Dang... sorry Eric... got so tied up in the theory of it all, I forgot to demo how to do it set based...

Most of the SELECT list in the code...

If that's the case... I'd just drop both tables and the related keys and start them over... but, unless it's for repopulating tables for testing purposes, I'd still like to...

Yeah... I forgot that you've been around a long time... didn't even read to see who did the post, Farrell. 

Speaking of being around for a long time, whatcha doin'...

Don't forget... temp tables are tables, too.  You can add indexes...

You also need to make the 2nd line of the format file equal to the number of columns listed in the format file...