If they need to run sequentially, create a single job with 10 jobsteps.

If they need to run at the same time, create 10 jobs.

From the Books Online documentation for the DATEPART function:

"When datepart is week (wk, ww) or weekday (dw), the return value depends on the value that is set by using SET...

You got your solution, but I like to explain why your solution failed.

The LEFT JOIN you used (in itself, without the selection on date) will produce at least one row...

A backup is not intended as a tool for export. It is a tool for disaster recovery.

There is no way to exclude specific tables from a backup, unless you planned...

Is the problem reproducable?

Have you checked if any blocking was going on during the second execution?

alex_fajardo2002 (2/3/2016)

---

Hugo Kornelis (2/3/2016)

---

So you want to add a generated column that can be combined with the Year column to become a composite candidate key? Okay.

"How do I do this...

Create a table for storing the results.

For each stored procedure you want to time, add a variable @StartTime (or choose any other name, especially if this name is already used...

Steve Jones - SSC Editor (2/4/2016)

---

In most cases this works well. In a DR situation, it could be problematic, though I'd hope you keep the previous snapshot before taking another....

Raxter (2/3/2016)

---

Thank you for your reply. I already know that the Health table will not have as many records as the Child table. The rev_id can be assigned to more...

Luis Cazares (2/3/2016)

---

Hugo Kornelis (2/3/2016)

---

At first I had the server option selected as well.

Then I recalled that the connect option at server level is actually called CONNECT SQL, not just...

sc-w (2/3/2016)

---

So to clarify the, the results I want to see are only properties that are vacant, where the start and end time, along with times do not overlap that...

Chris addressed the question in the title. I'll address the question in the body, whether this is a good idea. Usually it isn't, but sometimes it is the least of...

That's a lot of sample data. But I guess I should not complain, too much is better than none at all and at least you posted scripts that worked immediately,...

Oh, I know how to fix it, no worries.

But far too often I just start with a copy/paste of the string I am searching for before I realise that there's...

My guess is that the comments in that procedure contain a sentence such...