dynamic interval creation in SQL
I have the following problem, that I would like to solve with transact-sql.
I have something like this

Start End Item
1      5   A 
3      8   B

and I want to create something like

Start End Item-Combination
1      2    A      
3      5    A-B
6      8    B 



For the Item-Combination concatenation I already thought of using the FOR XML statement. But in order to create the different new intervals... I really don't know how to approach it. Any idea?

thanks
dynamic interval creation in SQL
===

I have the following problem, that I would like to solve with transact-sql.
I have something like this

Start End Item
1      5   A 
3      8   B

and I want to create something like

Start End Item-Combination
1      2    A      
3      5    A-B
6      8    B 



For the Item-Combination concatenation I already thought of using the FOR XML statement. But in order to create the different new intervals... I really don't know how to approach it. Any idea?

thanks