M_E_K (9/20/2012)

---

Bit of a breakthrough on this I thought I'd share....

There is an undocumented flag, -T1229 which turns off Lock Partitioning on SQL Servers with >= 16 CPU.

Once I...

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

...

Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings...

Nils Gustav Stråbø (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

Well, I didn't say never to use it, I...

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

...

Luis was able to help because at the time he had no opinion of me or the thread and wasnt letting his feelings stop him from...

asm1212 (9/20/2012)

---

Michael Valentine Jones (9/20/2012)

---

This code will work for any date within a quarter to find the end of month for the three months in the prior querter.

select

CurrDateTime,

PriorQtrMonth1 = dateadd(mm,(datediff(QQ,0,CurrDateTime)*3)-2,-1),

PriorQtrMonth2...

erics44 (9/20/2012)

---

I had...

Overflow, you are trying to convert the number 634 to a string but only giving the string 2 characters of...

PiMané (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

You are trying to make design decisions before any coding is actually done. The answer is "it depends." What should be done is to develop...

erics44 (9/20/2012)

---

Lynn Pettis (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I...

Have you tried putting the option (maxrecursion 0) on the calling SQL?

You are trying to make design decisions before any coding is actually done. The answer is "it depends." What should be done is to develop several alternative solutions...

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess Luis has...

Only other option I can think of is at the end of the calling query.

Using the info from the url Sean provided and making some tweaks I would suggest something like this:

declare @RunDate datetime = '2012-10-01';

select

dateadd(dd, -1, dateadd(mm, datediff(mm, 0,...

I would say it should look like this:

...

SELECT Text_Id, TextData

FROM FindReplaceCTE

WHERE LookupIdx = (SELECT MAX(LookupIdx)

...