chandu1551
2/2/2017 - 6:17 PM

Audit Type Wise Subsection Weightage.sql

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