Cacher is the code snippet organizer for pro developers

--SELECT * FROM dbo.Audit a ORDER BY a.Id DESC
DECLARE @auditId BIGINT = 43753

SELECT ad.Id
	,ad.AuditId
	,hmSubsection.Id AS SubsectionId
	,hmSubsection.NAME AS SubsectionName
	,hmGroup.NAME AS GroupName
	,ad.QuestionId
	,ad.ConfiguredWeightage
	,ad.Answer
	,ad.ObtainedScore
	,ad.LegendStatusId
	,ad.Comment
	,qm.QuestionText
FROM dbo.AuditDetail ad
INNER JOIN dbo.QuestionMaster qm ON ad.QuestionId = qm.Id
INNER JOIN dbo.HierarchyMaster hmGroup ON qm.HIERARCHYID = hmGroup.Id
INNER JOIN dbo.HierarchyMaster hmSubsection ON hmGroup.ParentId = hmSubsection.Id
WHERE ad.AuditId = @auditId
ORDER BY hmSubsection.OrderNo
	,hmGroup.OrderNo
	,qm.OrderNo

SELECT asd.Id
	,asd.AuditId
	,asd.SubsectionId
	,hmSection.NAME AS SectionName
	,hmSubsection.NAME AS SubsectionName
	,asd.SubsectionQuestionCount
	,asd.MaximumScore
	,asd.MaxAccountableScoreAtSubsection
	,asd.SubsectionWeightage
	,asd.ObtainedScore
	,asd.ObtainedScoreOnWeightage
	,asd.SubsectionScoreInPercentage
	,asd.SubSectionRating
	,asd.IsActive
	,asd.CreatedBy
	,asd.CreatedDate
	,asd.ModifiedBy
	,asd.ModifiedDate
FROM dbo.AuditSubsectionDetail asd
INNER JOIN dbo.HierarchyMaster hmSubsection ON asd.SubsectionId = hmSubsection.Id
INNER JOIN dbo.HierarchyMaster hmSection ON hmSubsection.ParentId = hmSection.Id
WHERE asd.AuditId = @auditId
ORDER BY hmSection.OrderNo
	,hmSubsection.OrderNo

SELECT asd.Id
	,asd.AuditId
	,asd.SectionId
	,hmSection.NAME AS SectionName
	,asd.MaxScoreAtSection
	,asd.ObtainedScoreAtSection
	,asd.RatingAtSection
	,asd.IsAnyRedalertRaised
	,asd.AuditSectionStatusId
	,asd.SectionActionPlanComment
	,asd.AcknowledgementComment
	,asd.IsActive
	,asd.CreatedBy
	,asd.CreatedDate
	,asd.ModifiedBy
	,asd.ModifiedDate
	,asd.AuditingCompletedBy
	,asd.AuditingCompletedDate
	,asd.CoachingCompletedBy
	,asd.CoachingCompletedDate
	,asd.FeedbackSentBy
	,asd.FeedbackSentDate
	,asd.AknowledgedBy
	,asd.AknowledgedDate
FROM dbo.AuditSectionDetail asd
INNER JOIN dbo.HierarchyMaster hmSection ON asd.SectionId = hmSection.Id
WHERE asd.AuditId = @auditId

SELECT *
FROM dbo.Audit a
WHERE a.Id = @auditId