Not if you want to include anything outside of the U.S.A, Canada, or either of their NANPA territories.

The country code for [font="Arial Black"]any [/font]telephone number that has an NPA/NXX (Area...

Joe Celko (1/17/2009)

---

If SQL Server was up to ANSI/ISO Standards, we would have POSIX style regular expression in the SIMILAR TO predicate, like other SQLs. This is one...

I understand what you're trying to say, my dear ol' and trusted friend... but there is no time in the past nor anytime in the future where I have or...

GSquared (1/16/2009)

---

I doubt whatever server SSC is using could hold a complete list of everyone who has ever deserved one of Jeff's porkchops! There just plain isn't that much...

GilaMonster (1/17/2009)

---

You're not the only one. I did so earlier in the week in a comment about a correlated subquery.

The difference is that it's not common and we correct it...

Grant Fritchey (1/17/2009)

---

Ninja's_RGR'us (1/17/2009)

---

So what?, only 2 people on that thread answered without reading (or understanding) the question.

Since when reading the full question a requirement of posting an answer?

😀

Maybe it's...

GilaMonster (1/17/2009)

---

Not a bad question, but does this guy ever read the posts that he's answering?

http://www.sqlservercentral.com/Forums/FindPost638650.aspx

Question was "I didn't start an explicit transaction, I don't have a backup, how do...

jon.skin (1/17/2009)

---

The examples of crosstabbing given are very good by only work with numeric crosscasting.

If you try a similar method with textual columns you cannot use GROUP BY because you...

Don't, even for a second, think that I'm trying to fan any flames here. 🙂 I'm only interested in knowing because you guys have probably forgotten more about...

Me too and I'm very happy it wasn't me that got the...

GilaMonster (1/17/2009)

---

I've got a similar one that I'm working on, that does have a legit business requirement. I don't need a solution, I did figure one out after staring at...

I've checked in your recent posts on this thread and I'm not seeing a link that you posted. I'm probably just missing it... would you do me the favor...

TheSQLGuru (1/17/2009)

---

Did you actually read the link I sent - fully, including the link at the top to the original article (which I explicitly called out in my post)?? ...

TheSQLGuru (1/17/2009)

---

1) IIRC for some of your running total solutions and other set-based examples here (especially the ones using update @var = @var ... trick) you put the entire set...

Heh, ok, you said it, now prove...