CirquedeSQLeil (2/16/2010)

---

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the thread above,...

RBarryYoung (2/16/2010)

---

Sooo... Five hours after I worked to produce a completely correct and valid answer to your question (and in...

Chad Crawford (2/16/2010)

---

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the...

michael.morse (2/16/2010)

---

Yeah I have seen that article. I was hoping there would be something that states that transaction logging is controlled at the database level by selecting the proper...

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the thread above, and at...

Sooo... Five hours after I worked to produce a completely correct and valid answer to your question (and in less...

C4 is a plastic explosive with a particularly high "burn rate" or (more properly) detonation velocity of 28,900 kph.

In fact, for the longer-strings, an abbreviated Boyer-Moore Search and Replace (or an unabbreviated one for really big strings) should be freaky fast.

(edit: fixed spelling)

Hmm, this all seems like the kind of thing that a CLR UDF should burn through like C4.

And just to warn you ahead of time: If you are looking to write this as a T-SQL Function, be aware that they do not allow dynamic SQL. ...

I...

What constitutes "consecutive"? There are no other intervening fees.

I don't understand this. PartID 1 has 4 absences in a row and PartID has 3 in...

Well, it's certainly obtuse, but this is one way to do it:

SELECT (

Select CAST(C AS XML)

FROM (

...

Hmm, I'm not sure that there is a good way to do this.

It sounds like someone wants an "XML Cursor" and there really isn't such a thing in T-SQL. An...