Andy,

THANK YOU, THANK YOU, THANK YOU!!!!!

In the bowels of your code, I finally found what I've not been able to find anywhere else... a replacement for using xp_CmdShell (security risk)...

Interesting...

I may have a method that might even beat ASP.Net for performance but I need to know, does your table have an auto-numbering IDENTITY column?  And, it doesn't matter if...

Too bad... I think this was homework and didn't see where Paul tried...

I don't believe it's returning the the latest identity value unless someone put a trigger on the table that does so.  Check to see if there are any triggers on...

Sorry Kenneth... didn't exactly return the favor.

My Tally table is 9999 rows, single "n" column is INT with a Clustered PK.

The million row test table is made up of 6...

Yep... I'd test it... "it depends" and the age old adage of "one measurement is worth a thousand speculations" still holds true.  It's especially true in the world of multi-processors......

The following is wrong because it leaves out one entire second of the day...

BETWEEN '2006-05-01 00:00:00.000' AND '2006-05-01 23:59:59.000'

...depending on the source of the data, there could be thousands...

The reason I ask is because I DO have a Clustered Primary Key on the N column of my Tally table and here's the results I got from the 3...

Kenneth,

Does your Tally table have a Primary Key?

Jeff,

Great use of a Tally/Numbers table... is more than twice as fast as the WHILE LOOP method...

Shifting gears.... in your code, change this...

select @address = '1300 teseter 234'

...to this...

select @address...

Nope, no experience with GPS phone providers here, either.  But what you have planned  not only sounds very feasible, it sounds like a hell of a lot of fun, too! ...

Here's the example xp_CmdShell code I will sometimes use... note that I always include the hardcoded DOS command DIR and I always include the path in double quotes to help...

Not sure exactly how you would do it in DTS but I'm thinking that if you built some error logic around the fact that the files are empty and that...

Another country hear from!  Also, very neat, David.  Interesting use of SIGN as a "lump detector".

Juliano... has one of these 3 solutions provided you with the answer you needed?  They...

... except to continue Shows how much I use loops and I didn't read the code well enough..  Thanks for the clarification...