Thanks this function worked. Of course, I had to change it a bit but it is one of those lessons learned for future use. Again, Thank you.

That did it. Now to figure out and understand just exactly what you did. I love learning new stuff. Thank you.

Correct, in this instance they are geographically regions.

so

ID name ...

That is exactly what I needed.  this worked perfectly.  Thank you tremendously.

I want to insert data from two tables into one table.  The inserted table is similar in structure to one of the tables that I want to insert from.  The...

SQLBill,

Thanks that was a great starting point and exactly what I needed.  I did change it up a bit.  I still need the first four column values but I wanted...

also, I want to create a sp that will allow me to plug in optional parameters.  These levels can traverse down to level 5.  So each subsequent call to the...

The sql runs fine when I do not include the where AT_Active <> 'true' which does not make sense when it equals null at the moment.  I will play around...

Yes, the MF_ID Is the the primary key.  I change the MF_ID to a value that only returns Level1ID, Level2ID and Level3ID.  Level4ID and Level5ID are NULL.  The select statement...

Ok, that worked fine for when the select statement return values for each level, there are times however that some levels may return null.  How do I account for those...

That worked great, thank you.