Cacher is the code snippet organizer for pro developers

SELECT * FROM dbo.AuditStatusMaster asm
SELECT * FROM dbo.AuditSectionStatusMaster assm


DECLARE @audit int = 7317
SELECT * FROM dbo.Audit a WHERE a.Id = @audit
SELECT * FROM dbo.AuditSectionDetail asd WHERE asd.AuditId = @audit
SELECT * FROM dbo.AuditSubsectionDetail asd WHERE asd.AuditId = @audit
SELECT * FROM dbo.AuditDetail ad WHERE ad.AuditId = @audit


SELECT *
FROM dbo.vw_AuditDetailInWhole vadiw
WHERE vadiw.AuditId = 7327
ORDER BY vadiw.CEOrderNo
	,vadiw.SectionOrderNo
	,vadiw.SubsectionOrderNo
	,vadiw.GroupOrderNo
	,vadiw.QuestionOrderNo