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

Table variables are not necessarily faster than Temp tables... they do not and cannot be made to use statistics...

Also, if you think that table variables might be faster because they...

Ummm.. Post the code for the offending proc?

Develop a weekly maintenance plan... see Books Online for how...