Testing a query in 10.2.300.11 Error BAD SQL Statement, where it is working fine in 10.0.700

Ok. Got it to work !

PartTran was part of this query and one thing to avoid is looking into this table… :wink: Anyway the info retreived was available via the jobs tables so I removed it. I did so many changes I can’t remember which one(s) resolved the issue…:thinking: But the good news are that the query was able to run…

And it ran in less than 6 seconds…

But still… I am stunned to notice such difference between the two versions !

Thanks all for your support!

Pierre