You're ignoring bad rows? 

You really want to get good at performance tuning?  Start answering questions on this forum   And learn how to make millions of...

Tim,

Thanks for letting my "rant" in... I don't know if we can help you with that nasty cursor, but if it's not hundreds of lines long, maybe you should post...

Tim,

This isn't going to help you a bit... I just want to make a point to any others that may read this because it's been an ongoing battle on this...

Ok... let's stop pussyfooting around... your original post, with the correct indexes on the columns, runs as fast with the Order By as without... it screams.

Now you throw the curve...

The limits in SQL Server 2000 are a bit bigger than that (from BOL)...

ntext

Variable-length Unicode data with a maximum length of 2³⁰ - 1 (1,073,741,823) characters. Storage size, in...

You're still missing the point... you provided certain base data in your original post and an output sample that cannot be...

I'm just asking for you to provide the correct output...

Your database is "case sensitive"?????

Passing any parameters to the sproc?  If you are, post the code so we can take a peek for ya...

You're simply trying to do too much at once in each section... you must "Divide and Conquer" if you expect to get any performance out of this.

First thing I notice...

Cool... thanks guys. 

If that is what you must do, then the TEXT datatype is certainly one way to go.

To see if the Standard Edition will create a table with multiple text columns,...

Sure, Karthik... let's answer question #2 first...

'dtProperties' is a special table used by things like the "Visual Database Design Tools".  It even has to be modified if you want to...

Perfect... thanks, Bill.

Josef,

Need a couple of things from you...

1. Would you post the first 10 lines from any of the files?
2. Would you post the table creation statement for the StockData table?
3. If possible, would...