Mauro, I'm looking at your post right now...

Sorry, Mirko... I missed your post from way back in February...

You wrote "I don't need statistics on temp tables, because I usually know enough about their structure and data that...

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...