Wonderful solution, thank you!!

Hi again

your suggestions were indeed correct.

I split the CTE in 2 smaller CTEs and everything is working perfectly now with great times. :w00t:

So what's the teaching here (for the community)?...

Thankx for your reply.

Here you (should) find 4 attachments:

- the 2 plans in the different conditions (with and without INTO in the final select)

- the query

- the...

1) I am sorry I didnt follow the directives to post a request about optimization. I didnt do that mostly because I (think I) already have a good plan that...

After a lot of tries I found the reason for this behaviour.

I had set the property Disable of each SP to "False" instead of the default "True" and this causes...