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

At the risk of sounding a bit snippy (don't mean to)... the best performance enhancement tool is your brain.  You've already isolated which procs are running slow... look for and...

Absolutely agree on the proper use of a correctly indexed temp table.

Jimmy...

Can't use just 60... that would imply integer math.  It has to be 60.0 to imply that it's a float calculation with decimal places.  I also believe that "value" is...