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

Step 1 = schedule logic
Step 2 = sp1
Step 3 = sp2
Step 4 = sp3

Presumably where you are the first business day of the month is...

Use xp_cmdshell to call the PowerShell command from a stored procedure.  That's probably the simplest way.

John

I know next to nothing about Oracle, but I'd guess that "integrity constraints" might include data types and check constraints as well as primary and foreign keys.  Have you tried...

Sounds like a job for PowerShell.  The PowerShell commands come with the AD client tools, if I remember correctly.  Or you could set up a linked server to AD and...