Comin' right up...

There's a function in SQL specifially designed to handle IP addresses and similar naming... your instructor probably told you about it. 

Never mind... I found it... should I tell him about the function that's specifically designed to take care of IP addresses?  NOT!!!

Sorry Gail... operating on my first cup of coffee Do you have the URL for that?

I share the same thoughts.  You've certainly got the right idea about improving your own skills.  Even though I've been doing this for a while, I still learn new things...

Heh... Wasn't going to say anything about that so it wouldn't change anything but, I absolutely agree, that's normally a prime give-away.  Another dead give-away is the level of urgency even if...

I'll be the first to agree with making the end result pretty... I'm just not sure why they don't do that at the presentation layer... or, maybe that's the problem? ...

Heh... nice job Serqiy... guess I didn't have enough coffee   I didn't think of the crosstab-like solution.  Very cool.

Hmmm... I'm using SQL Server 2000 sp4 Developer's Edition and it works fine...

Heh... THAT would be funny, indeed.  Thanks, Antares...

My pleasure, Maqy... thank you and James for the feedback.

You don't need to archive as an "Excel" file... just export it as a Tab delimited file and reimport if you need it.

If you don't have SA privs, BCP would...

Simple, elegant, and nasty fast, James.  Well done...

If you use BCP along with the "Simple" Recovery Mode on a staging table with no indexes and no triggers, the load of 150,000 rows should take no more than...

Thanks for the feed back James and Nickie...