Rogue code is right 😉

This extended stored procedure is undocumented and might stop working one day, format your hard drive, or...

Good job I'm never giving up 😉

You don't even need to go to the trouble of creating the invalid/unknown groups - just use...

Two things on the PARSENAME conversion routines:

First, T-SQL scalar functions have no place in this world - the routines would be much more happily expressed in an in-line table-valued function.

Second,...

cheyursenthil (4/15/2010)

---

HI , JUST TRY TO THIS

alter table <TABLENAME> add gid timestamp

delete from <TABLENAME> where gid not in(select max(gid) from <TABLENAME> group by Field1,Field2)

alter table <TABLENAME> drop column gid

Note: Field1,Field2...

RBarryYoung (4/14/2010)

---

The problem with the articles here at SSC, is that unlike the forum posts, we have no way to see how someone's formatting tricks are done, so we cannot...

Agreed. I was using 'class A' as a quick way to refer the the first octet -...

Thanks - that clarifies the details of the 64K range idea nicely 🙂

Of course, I...

PaulB-TheOneAndOnly (4/14/2010)

---

Who said that?

Documentation Paul provided clearly reads "master" database...

bobmclaren (4/14/2010)

---

I'm back with good news!

I was finally able to get around to changing that code and implemented the permanent table solution. As a result, the default trace logs...

Always nice to get a happy ending 🙂

Great! Because I...

Your US IP address range is 6.0.0.0 to 7.57.75.31...

One other thing, timotech:

TOP 100 Percent ORDER BY Considered Harmful:

http://blogs.msdn.com/queryoptteam/archive/2006/03/24/560396.aspx

Just in case anyone finds it useful, here's the code I used to compact the records:

-- Compacted version of the full allocated-IPs table

CREATE TABLE dbo.IPtoCountryMap

...