Audit Type Wise Subsection Weightage.sql
SELECT asd.AuditTypeId, asd.HierarchyNodeId, asd.Weightage,hmSubSection.NAME hmSubSection, hmSection.NAME hmSection
FROM dbo.AuditTypeXSubsectionWeightage asd
INNER JOIN dbo.HierarchyMaster hmSubSection ON asd.HierarchyNodeId = hmSubSection.Id
AND hmSubSection.IsActive = 1
INNER JOIN dbo.HierarchyMaster hmSection ON hmSubSection.ParentId = hmSection.Id
AND hmSection.IsActive = 1
--WHERE asd.AuditTypeId = 1
ORDER BY asd.AuditTypeId