>Using SQL Server 2008
>
>Does that change your code suggestion? Thanks for your help.
No, but you can also use CTE approach as well.
I was also thinking that you may go away with windowing functions, but it doesn't seem to be good for your problem, though we can, of course, if we, for example, wanted to add the first Item info along with the rest.
If it's not broken, fix it until it is.
My Blog