Chandrashekar
2/13/2017 - 5:46 PM

ODC Report Scripts

ODC Report Scripts

EXEC USP_Rpt_AuditDetails

EXEC USP_Rpt_AuditsSubSectionScoreAndQuestionComment_Pivoted

SELECT *
FROM vw_AuditTypeXSubsectionWeightage
ORDER BY AuditTypeName
	,SubsectionOrderNo
	,SectionOrderNo
	

SELECT *
FROM dbo.vw_GetAuditTypeWiseHierarchyQuestions vw
ORDER BY vw.AuditTypeName, vw.CEOrderNo,
	vw.SectionOrderNo,
	vw.SubsectionOrderNo,
	vw.GroupOrderNo,
	vw.QuestionOrderNo	

	
SELECT *
FROM vw_GetHierarchyMaster vw
ORDER BY vw.LevelId,
	vw.OrderNo