This is right on the border line of me thinking this is some type of homework... please post a decent try!

I will give you a hint, though... lookup GROUP BY.

Try it... let us know...

--===== Create and populate a 1,000,000 row test table.

-- Column "RowNum" has...

What size column do you thing NAME = '' will make? Also, look at the update... which NAME shall it use to do the...

RyanRandall (7/14/2008)

---

Another technique which can be useful in some circumstances...

update #TEST set Descr = replace(replace(replace(Descr, ' ', '¬ '), ' ¬', ''), '¬', '') where Descr like '% %'

(Where...

Ok... now that I've had a bit of coffee... 😛

In the original problem posted, San didn't care about which name was returned so just use the MIN or Max name...

I believe that...

Heh... Sure! ...

I wouldn't recommend that way... it has a While loop in it and a couple of other performance related problems. Try the following, please... it also explains how it...

There are a couple of ways... I believe the fastest for large data sets in SQL Server 2000 would be in the following...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

riga1966 (7/15/2008)

---

Hi Jeff,

I think you are right.

I replaced UPDATE code and ran it.

But it now gets stuck inside a loop.

I run this SP a a script. I put lots of...

Heh... you guys are missing the real problem! 😉 The real problem is why does the OP NOT care about which data is returned? If you don't care,...

Heh... I feel the same... but I said "Today, just this one day, I shall not rant." 😛

Let's see how you would do that, Karthik... 😉

I know disk space is relatively cheap... I just can't bring myself to suffer the overhead of storing XML in a database anywhere except a temporary staging table. With...

THAT is one of...