Generating a family tree

Transact-SQL
1

Heya comrades,

I have an excel sheet which contains data about children and their parents, profile etc. I am interested in creating a family tree whereby every child is linked to their parent/Household (father/mother/guardian) which are captured in separate columns within the same sheet. I imported the file into MS Access and have tried to query it in different ways but i have not succeeded in getting that missing query. It's quite a big list (over 2000 records) and i cannot not do it manually.

Any support will be highly appreciated.

Absolom

2

This will help you. Please go through the article having an example

https://technet.microsoft.com/en-us/library/ms186243%28v=sql.105%29.aspx