Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  help with a sp

Author  Topic  rdz555 Starting Member 6 Posts Posted - 2009-06-07 : 20:40:40 consider 5 subjects : A, B, C, D and E. subject A is the father of the subject B. Subject C is the brother of the subject B. subject D is the son of the subject B. subject E is the son of the subject C. Write a stored procedure that takes as parameters two of the 5 subjects and return their family kinship.