Resource Search

SELECT DISTINCT(vchAuthorityAbbreviation), idGuidingDocument FROM GuidingDocument WHERE idGuidingDocument != 0 ORDER BY vchAuthorityAbbreviation SELECT DISTINCT SyllabusName FROM Syllabus WHERE TeacherID = 2497 SELECT DISTINCT(su.SectionID) AS SectionID FROM SectionUnit su, Syllabus s WHERE s.SectionID = su.SectionID AND s.TeacherID = 2497 AND s.SyllabusName = "#Form.selSyllabusName#" SELECT DISTINCT(su.SectionID), su.SectionUnitID, su.Assignment, su.URLString, su.Comments, su.CustomTestID, u.FileType, u.FileName, u.Description, u.rel_idResourceComponent, u.Type, u.KeyWord, u.UnitName, u.Objective, u.UnitID, grl.rel_idResourceComponent, gds.vchDottedHeirarchyLevel, gds.txtStatement FROM SectionUnit su, Unit u, GDS_RC_Link grl, Syllabus s LEFT JOIN GuidingDocumentStatement gds ON grl.rel_idGuidingDocumentStatement = gds.idGuidingDocumentStatement AND gds.rel_idGuidingDocument = #Form.selStateCorrelation# WHERE s.SectionID = su.SectionID AND su.UnitId = u.UnitID AND grl.rel_idResourceComponent = u.rel_idResourceComponent AND su.SectionID IN (#strSectionIDs#) ORDER BY s.SecOrder, su.SectionUnitID SELECT Subject, Objective, CustomTestID, TestName, Topic FROM CustomTest WHERE TeacherID = 2497 Resource Search

No correlations yet. Or no requirements for this state.

Assignment Name

Type

Description

#Assignment# #Assignment#

This is a custom test or worksheet User Defined HTML Lesson #Description#

Number	Statement Text
#vchDottedHeirarchyLevel#	#txtStatement#
No correlations yet. Or no requirements for this state.