ow many are active from each group. Return the answers in one query and put the results in a table variable.
a. Paths
b. Courses
c. Sections
d. Events
2. How many documents have been created but not attached to the Curriculum.
3. How many active events are there in each Course? Sort from largest to smallest
4. Create a View that outlines the whole curriculum in the correct order.
5. How many of each Event Type’s are included in the Active Curriculum.
6. Create a SP that accepts CourseID as a parameter and returns SectionName, DocumentName and EventType’s stored in the Course passed into the SP.
7. Create INSERT Statements to add 1 record into each of the 6 tables.
The post documents have been created but not attached appeared first on My Assignment Online.