Great!

Thanks again (for getting carried away)!

Thanks Andras!

why do I have the feeling that it should be

FLOOR(AVG(...

and not

AVG(FLOOR(...

?

again... just a feeling

Ok, deleted and inserted, not updated

That worked well

Thanks for the help!

Great help!

Tx!

I am not really expert in SQL, but i did that, i get numbers:

Index seek cost

RID lookup cost

so I guess if these are high, then it' not good?

and of course...

mmmm not sure... it's a pre-written application, and I can't change much in the core code.

Can you give an example of what it would be?

tx!

it's a rich client application

Actually, I think i complicated the question

I would like a count of the articles, grouped by article, no matter the store... but if i...

this could be good, but it will give me results under the following format:

              st1count  st2count   st3count

article1        10             0            0

article2         0              20          0

article3         0              0          ...

ok, here it is:

table:

john , SMS, 55533366

john , email, j@j.com

mike , SMS, 22663355

mary , email, m@m.com

the output would be in the view that has 3 columns: id, SMS,...

and what if i know how many contacts type i have? actually right no i only have 2...

AHA! BUT...

what if i dunno the exact number of products to be tested?

i.e in may interface, the user can enter 1 to 3...

well clientsproducts.product in ('xxx','yyy','zzz')  means that the client should have any of the 3 products, while I want him to have the 3 of them, i.e I want to find 3...

i will rephrase with and example

i need to search for all clients who have a given list of products

so i'm searching in my...

ok got it

loads of thanks!