Well, not really... if you have a hundred million row table and you isolate a million of those rows in a temp table for some SQL prestidigitation, for example...

Or you...

Are you storing numbers that you will calculate with in that column??? World of hurt getting ready to happen there... $ won't let you do calcs unless you first convert to...

How's 'bout running Steve's riding lawnmower underwater?  

I'm the luckiest guy in the world… my Dad made the coolest "gadget" I've ever seen except it's...

Other queries did top/bottom 10% of the whole table which is why you got such a disparity in rows... Serqiy's does it correctly by the key column...

When you say the tables have "no indexes on them", I'm hoping that you at least have a primary key   If not, you...

Part of the problem with table variables is they do not nor can they be made to use statistics... table variables should be kept relatively short... changing to a temp...

Or, just set if to off... won't produce an error if it's already off.

Thanks, Andy...

That's the ticket... Thanks, Lynn.

Heh... melted the filter...

Dearest Moderator's,

How can I make it so I'm no longer "watching" (unsubscribe) this topic?   We've gone from "Banker's Rounding" to actual "Digital Truncation"...

Oh, bugger... I forgot about the check constraint thingy... Andy, I've temporarily lost my mind and my notes... can you review/provide a brief summary how the check constraints improves the performance...

It depends...

How many stocks do you need to do this for and how often?  Very well may be better to do it...

Recommend you write a macro to export the section of the spreadsheet as a tab or comma delimited text file and import the text file.