Topic: It is a lot of with or temporary tables
There is a theoretical question.
At a forum did not find a similar subject, and on msdn - performance comparisons of approaches.
I write request.
In it there are some units which can be carried out in with before the main request or to collect in temporary tables and then already to use them.
If 100 in units and them it is more than data of the order 3, what will faster work?
With an as (), b as (), c as ()