Thanks to all of you!
I was hoping there was an other way than handling with different tables to transfer the data... But nevermind, thanks for the very interesting solutions,...

Thanks a lot, that solution worked perfectly!!

A colleague of mine also found a similar solution:

SelectName1, Name2

from(Selecta.name as Name1,

b.name as Name2,

count(1) as Zaehler

from#temp1 as a

inner join#temp2 as...

Thanks for this suggestion....

unfortunately I tried that before writing my post.... It hadn't any effect on Intellisense shortcuts at all...

Do you delete all data on the destination table before you begin the transfer from the source?

If you always delete all data I have had a similar problem a...

Oops, sry I was kind of confused, i haven't seen that you wrote both answers :Whistling:

Yeah you are right again, truncate seems to be exactly the solution which will be...

This table is deleted and refilled by a job which runs at night, so there are no other queries which will be blocked during this Table hint.

But sure you both...

Thank you very much for your answer!

This was right the way i needed to think!

I spent over the last days a few hours by searching for fragmented Heaps like you...