Hello all,
thanks for your reply and sorry for this delay ..

@eirikur => sorry but my knowledge are basic ...how mucj traffic  / I/O performance ...
i don't...

Hello all,
Sean Pearce => i've check on the server...

Hello all,
HappyGeek => thanks yeah right ...

January 31, 2018 at 4:17 am

#1978010

Hello all,
thanks for your time and your knowledge that's really great to share it ...
sorry for the delay ...little problem at the moment  🙂

@lowell...

Hello ben.brugman ,Sean Lange ,Sergiy, Ed Wagner

After talking with my responsible of project and explain the difficult of this problem we have decide to migrate our table.

And stop to save...

Hello,

Thanks for your explantion and your time you spend here ..

You know my level in sql is equal to my level in English :> bad ..

it's your query who is...

Hello Right there with Babe, SSCommitted

thanks for your time your solution are different but work now it's my boss who must to decide witch solution keept

@sscommitted i don't...

Hello Luis, Anthony,

thanks for your time and your sample that's exactly what I want ..

yesterday before I leave my office I've begin a query with a case when column ...

Hello all,

thanks for all, I'm repeat perhaps 🙂 but that wonderfull to be find some help with this site ..

have a nice day

christophe

Hi yb751, Luis Cazares

thanks for your time that's exactly what I want ..

I don't know the function pivot but I can see that's very powerfull ..

@yb751 => your second query...

Hello Eirikur Eiriksson and Dean Mincic,

thanks for your time that's exactly what i want ..and now that's work ..

I don't know why the property of this object is initialize on...

hi both,

thanks for your time ans your solution ..

sqlcmd work really fine thanks and very fast..

Why we do not a back up restore ..

i think that the back up restore...

Hi all,

yes we must to have the same id value on the last model and new model

thanks for your script, i've try this today.

Have a nice day

Christophe

Hi,

thanks a lot that's work fine ..

thanks thanks you can't imagine i've try to find a solution about this problem while some hours ..

have a nice day

christophe

Hello,

the reason that they don't like the test IF in a stored procedure is due to the performance, they tell me that condition AND OR is better than a IF...