Dangit... sorry folks... I posted in a hurry and left out the underscore in ROW_NUMBER(). Andrew has the correct code and I went back to my previous erroneous post...

Lynn Pettis (3/20/2009)

---

You know, I was looking at it from...

Heh... I agree... all of the technology is fasinating. But the thing that increases my productivity the most is... downtime. Even the hour long drive to work is...

cmaciasg (3/19/2009)

---

Only a more questions, for maintenance issues.

How could manage all that stuff dinamically? That is, If the columns aren´t 3, but many of them, col1, col2, col3, ...., coln....

Then the query I included with my post should do it.

Florian Reischl (3/19/2009)

---

I've begun a new project and my predecessor used a char(10) field as the primary key in all tables. The key is generated by using the last 10...

My answer would be that the DBA chases you with a well equipped pork chop launcher until your heals smoke because you selected too much data. 😉

I'd have to ask what you're doing with CLR's that you think you can't do in T-SQL.

Nah... keep it all here so we might all learn something, please.

Cool... let's see it, Ramu.

Ok... again... here's the test data...

drop table #OriginalTable

go

SELECT '913.135.9000 x:6390' AS FullPhoneNumber

INTO #OriginalTable UNION ALL

SELECT '(305)529-6911x2101' UNION ALL

SELECT '(206)965-2626' UNION ALL

SELECT '109.391.3261' UNION...

Nope... bad move on my part... it's going to have to be a function because there's no guarantee that you won't have duplicate phone numbers after the split and that...

Ok Shamshad... you've got almost 400 points to your name. That means you've been around long enough to know how to post data for sample data to make it...

Lowell (3/20/2009)

---

ok i think i'm wrong about area codes between 100 and 199(starting with 1), so you might want to remove the logic i put in place to assume starting...

""Sameer"" (3/20/2009)

---

Hi,

How to querry a table that will give output like

1.Atleast one from this and atleast one from other.....

eg.1.Find the name of each student who has taken...