Thank you both for your fast help, justanewone i used your solution its works fine ! 🙂

Sascha

Thank you Lamprey13m.

I Modified your example, put that into a stored procedure and it works perfectly.

Greetings Sascha

As montioned there is no order in a set, so I added an IDENTITY column to mainatain that order. In the real world you would have some sort of order...

Thank you all for your fast response, but i dont think that XML thing will help me. My example is abstract, the real Table is much more complex. Please...