Sorting SQL server records for hierarchical relationships when there are more than one parent columns
I have following table wherein 2 (can be more) foreign key columns define self-relationship between records of the table.
I have following table wherein 2 (can be more) foreign key columns define self-relationship between records of the table.