Agreed.  I don't know why 3rd part vendors do that to us.   In those cases, though, I'll still do bulk processing to fill a staging...

Diagnostic Manager... Now THAT's useful and I understand what you mean, now!  That kind of monitoring tool can be priceless!  Thanks for the info, Colin.

If it's a gotta-have-it now type of thing, look at the proc and see if it uses GETDATE() to update any columns in tables... you might have to do a...

Bulk Insert does not necessarily require field separators if you use a format file.  Or, just use Bulk Insert to import to a single column tables and then use SUBSTRING...

Totally untested... should be nasty fast if the ID and StartTimeColumns are indexed.

 SELECT tc.ID,

        tc.StartTime,

        tc.StopTime,

        d.MinStopTime AS OriginalStopTime

   FROM dbo.TimeClock tc WITH (NOLOCK),

       ...

If you want strictly ANSI 92 compliant stuff, there's no need for a book on T-SQL...

Try http://www.w3schools.com

For the record, if you're one of those folks that insists on writing...

Aye... thanks Rudy... you made my day!

"Non illigitimi ie carborondum"

Ok folks... Dave and, I'm sure, Scott will be interested in this...

First, Scott posted what I call "QCSV" or "Quoted Comma Separated Values".  This is a format where the double...

That's kinda where I was going to take it but Scott already beat the heck out of his data provider...

That must be why I'm "a little behind" (Sorry, couldn't help myself )

it's always easier when you've been doing this for years,

Can't argue with that, Colin... it's why us old...

In that case, I'll give it a whirl... I was just "busy"...

It is just less typing in Query Analyzer...

... unless you cheat and use SELECT/INTO... if you are...

I believe that if you include "Reorganize data and index pages" in the {Optimizations} tab, fragmented tables are defragmented.

Nice job, Ryan... I was being lazy... not enough coffee that day...