Why in the world would you put a clustered index on a field that is likely to change EVERY time a new order is placed?

Adding the non-clustered index will solve...

It really all comes down to "people's" productivity and the server's reliability. If the People using the apps and the SQL Server are getting results in what they Perceive...

Excellent answer. Works perfectly in my initial test. I've never used the Join in that manner, can't see it shown in BOL (v 7) anywhere, but it works...

Your example works (brokenrulz), but it's not the whole answer. It only works for fields from the header table that can be in a group by. I want...

We've found that specifying the hardware correctly is of far less importance than carefully tuning queries and using ADO's ability to reduce round trips by grabbing multiple recordsets at once.

You've...

Thanks Jeremy, Andy for the lastest suggestions. As I indicated initially, SP_A is on my customer's machine, SP_B is on ours. I thought about returning a cursor, but...

Thanks mromm, I was just figuring that out for myself. Now I have exactly two reasons to move to 2000, the UDFs and the table variable type.

Looks like we're...

User Defined Functions don't exist until 2000, which we and our customer are not on.

But your comment implies that "table" is a valid data type. I wonder if I...

Yes, that's my fallback plan. Just hoping someone knows a direct method. Thanks for the quick post, though.

Student of SQL and Golf, Master of Neither

Sounds like a great article and tip.... Until you go to try it all out and you find that most of it doesn't work in SQL 7. It...

I vote for Antares' tip for "tip of the year" already even though we're just started.

I've used a friggin cursor to loop through and build a string containing email addresses...

Brian (I can't believe I'm arguing with one of the God's of the forum!):

I think you're assuming that I would call this bad SQL String in the simplest form with...

There are a lot of resources that give examples using different flavors of script languages, but thanks for that last one. My question was, and is, can someone write...

There is one other gotcha, it didn't start until one of the Service Packs (for SQL 7 anyway). The SP will get you data only in the current database....

I looked at the white papers, and they both suggest using "regular expressions" such as s/[^0-9a-zA-Z]//g to verify the user's input before passing it through in a SP to SQL.

Can...