Krishna_DBA (1/17/2009)

---

CREATE TABLE ContactPhone

(

--Numbers for NANPA--

CountryCode_NPAnvarchar(10),--Country code for NANPA DEFAULT '1'

AreaCode_NPA nvarchar(10),--Area code for NANPA

Exchange_NXX nvarchar(10),--Exchange...

No, no... look at what I wrote in my last post. 1 Table...

You give up too easy.

First, they've had such screens, admittedly with a bit less sophistication, as bar cash registers for years. It's just a different application of some old technology.

The other thing is,...

RBarryYoung (1/17/2009)

---

Jeff Moden (1/17/2009)

---

Correct. But even the estimated execution plan is "wonky" in that respect. I don't have the code example to prove it, but I've seen...

After that, ask yourself... "If...

Heh... science it out... how many parts of a phone number for a NANPA phone number and how many parts for an International Number?

arup_kc (1/15/2009)

---

Hi Gail,

This is actualy a question, which I have faced in an interview. I have tried with ROW_Number function later but no result.

That's why I have posted it....

I agree with Gus... it doesn't matter how many databases you have on a given instance of SQL Server... it's resource usage that matters. How many users are logged...

Yes... Select/Into will do minimal logging under the right conditions. But, it also builds the table... you would have to drop the target table first.

Simon,

I wonder if you'd do me a favor... I realize it's been about 4 months since the last post, but I need to ask... why did you need to do...

rog pike (1/17/2009)

---

Jeff Moden (1/16/2009)

Heh... Come on folks. "We don need no stinkin' CLR!" 😛 This is a simple problem and it doesn't need a CLR. ...

Correct. But even the estimated execution plan is "wonky" in that respect. I don't have the code example to prove it, but I've seen where a Loop...

Heh... my first program was using punchcards on Unit Record equipment that was "programmed" by putting banana plug wires into a rather large phenolic board that got insert into the...

Sushila's last login and post was on 2008-11-27. Last I heard from her, she was just incredibly busy. I sure do miss her good nature... makes the rest...