If you have very large groups and only a small number of them, this could be faster:

create table #x

(  company  char(1) not null,

 ordernum  int not null,

 sku  int  not null,

seq_num int...

You are right Phil, my query won't work, but it can easily be fixed, I think.... On the other hand, I am not sure either what the desired output is,...

Try replacing "join" by "left join" in Phil's query - maybe that's what you want?

Could you post the data contained in tables Test1, Test2, Test3 that will give you the output you have posted above?

Yeah, it wasn't because what you said didn't make sense

See you all in 3 weeks (vacation ...

I think he means

such that "A.strSurname like @strFirstLetter" will not be evaluated if "@SearchCol='SurName'" is false

Sounds reasonable - still I didn't know Thanks for the tips

This problem looks like the following problem:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=206795

The same type of solution can be applied. It's probably not better than Noel's suggestion, but it's an alternative

Well, I did, but that amounts to the same thing, as I only have it on one table - at least on my testserver

Well, my plan was to add a few indexes that should replace the statistics Anyway, the table is very small (max 100 rows),...

I agree with you (Remi is normally right ), I just didn't know you could use objectproperty.

Sounds very reasonable... However, I have decided to drop all statistics along with the indexes and then recreate the indexes - and hopefully...

Sure, a clustered index on every table, and other indexes as well... (except that it appears I was missing one...

OK, thanks a lot everyone...

I guess I will drop it and create the corresponding index on column PERSON_ID.

Run

select * from sysobjects where type='p' and status & 536870912 > 0

to find out which procedures are compiled with ansi_nulls on. I don't know about quoted_identifier, but that's...