You're joining TableA to TableB, and getting more than one row from TableB for each row in TableA.  You need to decide which one you want to use.  How are...

I'm thinking different permissions between the account that you log on as and the account that SQL Server runs under.  What do you get from these?

No, there's no advantage - only the fact that it doesn't have to actually take the locks.  But I'd be surprised if that difference were even measurable.  But if you're...

The taking of locks will only add milliseconds to your query.  It's waiting for locks to be released that NOLOCK helps with.  It's just telling the server to ignore a...

Kev

I'm afraid I'm still confused.  Please will you post a CREATE TABLE statement to show what your table looks like, and some INSERT statements so that we can...

Kev

It looks like you're on the right lines.  What is the value of "VALUE" for id that you want to update for?

John

Make sure that when they ask the "what do you know about our company" question (and they will), you can talk for 30 seconds, say, about the company.  Stuff like...

Actually, they are, Grant - with SnapManager at least.  Here's an example.

description                            ...

If you're not processor bound, then go with the filtered index.  There's no point in having lots of processors and not using them.  You'll also want to consider the cost...

Gavin

Here's where I usually start when faced with a deadlocking problem.

John

You've got a PRINT @sql line in your code: please will you post what it prints?

Also, please read about SQL injection, because you're wide open to it, and...

No, I understood it perfectly.  That's why the logic in Step 1 needs to test whether today (ie the day on which the job runs) is a business day.  It...