Thanks for the article.

My questions is : Suppose we need to relate one row data to two parents. By doing that I get only one instance of that data, not both.

I've added : INSERT INTO dbo.SampleOrg SELECT 14, 'Senior Director - Finance', 5

It is not reasnable in this example but it is reasnable in other.

How it should be done to accomplish this need.