seregak76 (7/19/2012)

---

GSquared (7/16/2012)

---

"Runnable" isn't about locks. It's about resource-availability. CPU, et al. It's waiting for a scheduler to be available to pick it up and actually get...

Jeff Moden (7/17/2012)

---

First, apologies for not responding sooner. I've actually be working on a demonstration...

As already mentioned, you can't do Select Into cross-server. In order to do cross-server DDL (including table-creation), you need to make sure the credentials used have the right permissions,...

In that case, I'd say build what makes the most sense to you, document it clearly, and communicate it thoroughly, and then don't worry about it till some line-of-business person...

Andy Hyslop (7/16/2012)

---

Jeff Moden P.S. A While Loop will actually beat the rCTE for performance here. It's not substantial enough to necessarily warrent its use but I thought I'd...

PAF is the UK counterpart to US PAVE. Sounds like it's a looser standard, if I'm reading it correctly, which means you will get more offbeat variations within it.

I...

Lynn Pettis (7/16/2012)

---

GSquared (7/16/2012)

---

Select ... Into ... is VERY different from Insert ... Select ...

The Select Into syntax will create the target table. If it already exists, you'll get...

Select ... Into ... is VERY different from Insert ... Select ...

The Select Into syntax will create the target table. If it already exists, you'll get an error message....

There isn't a direct equivalent.

If you want the number of months from one date to another, DateDiff will give the number of month-transitions in that span, but not precisely the...

jfriedl (7/16/2012)

---

well I don't have CLR and would prefer to not do anything with cursors, so what I will do is load a history table with all data prior...

Got it on the forward and backward bit. Seems like it would be easier to start at position 0 and query 2-character chunks for specific patterns.

As far as address...

If you're running into the recursion limit like that, you probably have an infinite loop going, as Jeff mentioned.

To get around that, without structural changes to the table (since you...

If this were the SQL 2012 forum, that would make sense.

First, why join up and down? Surely, if a character follows the same character, the one it follows also precedes it, and you don't need to detect both things.

Second,...

Start with an online search for "sql server wait states". You'll find a ton of information on the subject and can research it from there. It gets a...