Does the log table have an identity column? Did you try removing that column and see if the table is still locked? Typically multiple tasks should be able...

You certainly don't need a calendar table for that simple a calculation! All you need is:

SELECT (DATEDIFF(MONTH, 0, @enddate) / 3) - (DATEDIFF(MONTH, 0, @startdate) / 3) + 1

declare...

Hrothgar (9/4/2015)

---

That's a very good and very helpful solution; very many thanks.

As the results seem to come out in an arbitrary order, or at least in an order that I...

Jacob Wilkins (9/1/2015)

---

ScottPletcher (9/1/2015)

---

Jacob Wilkins (9/1/2015)

---

ScottPletcher (9/1/2015)

---

Jacob Wilkins (9/1/2015)

---

I know it's rather off-topic, but it's an interesting diversion, so I thought I'd just chime in on NOLOCK and temporary tables.

SELECT...

I can't see the screenshot. A screenshot is pretty useless anyway. Actual text would be much better.

But, in short, here's the approach I recommend:

1) encode the large varchar...

Lynn Pettis (9/3/2015)

---

ScottPletcher (9/3/2015)

---

Very busy at work, just now was able to complete the code. I'll go ahead and post it as an alternative. I prefer a "template"...

Very busy at work, just now was able to complete the code. I'll go ahead and post it as an alternative. I prefer a "template" approach, so that...

ben.brugman (9/3/2015)

---

Thanks Scott,

More elegant, more compact and it did uncover a mistake in my solution.

(My parent_column was not correct, I had not noticed that yet.).

Thanks,

Ben

Edit:

Second check,

, COL_NAME(parent_object_id, parent_column_id) as Parent_column

Does...

When you concatenate strings, you must insure that higher-precedence data types are first converted to strings. Try something like this:

SET @Q1 = N'exec RPT_MailOps '''+CAST(@ID...

Lynn Pettis (9/2/2015)

---

ScottPletcher (9/2/2015)

---

Lynn Pettis (9/2/2015)

---

ScottPletcher (9/2/2015)

---

Finally, there's the cost to fix each issue.

Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply...

Lynn Pettis (9/2/2015)

---

ScottPletcher (9/2/2015)

---

Finally, there's the cost to fix each issue.

Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply remove those specific...

Don't disagree with other comments. But maybe I can give you a quick fix, and maybe not.

First, you need an index on CSV_Details keyed first by Mark_Rev_No_fab that contains...

Finally, there's the cost to fix each issue.

Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply remove those specific bytes -- "WITH...

Lynn Pettis (9/1/2015)

---

Sean Lange (9/1/2015)

---

ScottPletcher (9/1/2015)

---

Honestly, though, I still think that overall the "use identity as the 'default' clustering key" myth is even more damaging than an "almost always use...

Lynn Pettis (9/1/2015)

---

Sean Lange (9/1/2015)

---

ScottPletcher (9/1/2015)

---

Honestly, though, I still think that overall the "use identity as the 'default' clustering key" myth is even more damaging than an "almost always use...