>I can't believe I have to explain this to an obvious experienced programmer like you.
>* Don't you agree that implementing a CTE is a splitting the query into CTE declarations and actual execution ???
>* Don't you agree that the definition and usage could be many pages apart, with loads of other non-related code in between?

Absolutely wrong. SQL is declarative language so using CTE you are splitting long declaration into smaller pieces that are easier to read


>
>>Cheap statements, me :) Ok let's be it. Keep the lego pieces and never ever use CTEs.
>
>Look up "Overused" in the dictionary. You're playing a game of denial here. I'd expect better from you. Very dissapointing.

You are expecting better from everybody but yourself. Very disrespectfull