Ummm..... that's a bit wierd if you try following the signature path of this one...

PW is correct AND....

You will probably have to use the machine name and path instead of drive name and path.  AND, your server must startup as something that has privs...

Here, Here!  Learn to work with NULLs on this type of thing.  There is a great value to NULLs in a column like this especially if you allow future enddating.

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...