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