How to select parents and children rows in SQL Server

How to select parents and children rows in SQL Server

References

Reference NO 1

http://stackoverflow.com/questions/15200899/how-to-select-parents-and-children-rows-in-sql-server

Reference NO 2

http://stackoverflow.com/questions/15461661/select-parent-and-child-records

Reference NO 3

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5e52baf8-8640-4474-beb4-7b286af081a8/action?threadDisplayName=select-parent-ids-that-have-exact-match-on-child-values-no-more-no-less

Reference NO 4

http://www.sqltreeo.com/wp/copying-parent-child-rows-and-sql-dependency-tracker/

Reference NO 5

http://www.mssqltips.com/sqlservertip/1943/using-a-parent-child-hierarchy-in-sql-server-to-implement-a-custom-security-scheme/

Reference NO 6

http://dba.stackexchange.com/questions/28116/single-sql-query-to-select-a-record-from-parent-table-only-if-all-its-records-i

Reference NO 7

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142025

Reference NO 8

http://forums.asp.net/t/next/1849347