SELECT first_appointment.*, next_appointment.*

FROM (

SELECT customer#, MIN(appoinment_date) AS appointment_date

FROM table_name

GROUP BY customer#

HAVING MIN(appointment_date) >= '20140101'...

You have at least one rule missing. For example, in

Text1=

'ABNAGENDRACSURENDRADJITHENDRAXNARENDRABVEERNDARAXDRMNDRAXRVINDRABNAGENDRACSURENDRADJITHEN'

The first A not followed by a B, C or D is "AGENDR". Why is that "A" excluded?

tobe_ha (9/4/2015)

---

ScottPletcher (9/4/2015)

---

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

Jacob Wilkins (9/4/2015)

---

Ah, thanks for posting that. I'd been having more trouble finding a 2008 instance than I'd expected.

So it seems 2008 (not R2) is the same as the others...

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