Hi everybody,

thanks for your time for to begin !

if i do a select len(PostionsList) i obtain more of 8000 characters !

and often i can have more on 8000 characters !!!!

here...

Hi everybody,

thanks for your posts,

i'd like to have your knowledge !

thanks for all to help me !

christophe

Hi both,

thanks for you time and your solution !

that's run now !

Thanks for all

Christophe

Hello Adam,

I don't know how to thanks you, your are very strong in sql !

Really really thanks

Have a nice day..

Christophe

You are too strong !

That work well very well

But could you tell me if there is a way more easy to do this ?

Because i can read the code but...

Just one thing i must to understand sorry !

Your query works well and enough easy to understand!

select p.person_id as Idpersonne,

sum(case f.actif when...

Hi Guys,

I would like to thanks you really because i've search to do this since several hours and i can't !

thanks thanks thanks !

Christophe

Hi Kenneth,

i've just copy paste your code it's work BUT there is just one problem who doesn't work !!!

the column NbActifFalse is always set to 0 it's seems that the...