Your solution works, but its slower than just creating a recursive function which is then selected as part of the select statement.

Thank you for your effort.

If you find another...

Thanks i will look at it.

Although it seems alot like my initial apprach using just a the view that i posted and a recursive function as you have written.

I thought...

I created a full example including tables, views and data required to test the SQL.

-------------------------------------------------------------------------------------------------

---- DATA STRUCTURE PREPERATION -------------------------------------------------------------

-------------------------------------------------------------------------------------------------

-- Create a Test Schema

CREATE SCHEMA TEST

GO

-- Create a table with parent/child...

Yes i know that examples ease the job of helping.

I left out the example, cause i wanted to see if anybody had been experimenting with the same type of...

Initialize the PeriodArray Variable with blank ('')

Further, why are you using a cursor? I think you could relatively easy refactor into a funtion, which has far better performance that a...

You could either make a UNION including the rows that are left out in your select.

Or you could start by selecting all records that you want a row displayed for,...

Try to post the Query.

You could probably archieve this by using af LEFT JOIN