Course-Summary
The Course
Summary stored procedure is a procedure that collects
information about the available course, in this way you will get
a list with numbers of items. I have created some extra views
to create also a course catalog (treeview) within this list.
The
ZIP-file contains:
-
Course_Summary_tbl.sql (Script to create the table)
-
Course-Summary.sql (Script to create the stored procedure)
-
Course-Summary_7.sql (Script to create the 7.x stored procedure)
-
IIF.sql (user defined IIF function)
-
Community_Catalog.sql (Script to create a sort of treeview
catalog for the communities)
-
Course_Catalog.sql (Script to create a sort of treeview
catalog for the courses)
Note:
The stored procedure contains about 40 columns that contain the
numbers of items that are found. There are 3 lines commented out
that could be usefull for you but requires some additional work
to create.
--Course_Summary.DTMODIFIED=
...
--Course_Summary.COMMUNITYCATALOG=...
--Course_Summary.COURSECATALOG=...
The first
one requires a table that calculates the last date a coures is
modified, that is part of my batch-archive script you can find
the stored procedure tables etc
Here.
The second and third lines are created by a view that uses a
user defined function to view a sort of treeview catalog where
the course/community resides. If you want to use these just run
them scripts inside SQL Query Analyzer, first the IIF.sql then
the other ones. Me advise is to use a seperate database for this
kind of stuff i did use a database bb_exceptions
for this
i know
that it is possible to split the assesment stuff into different
parts, but i didn't found the time yet to determine that kind of
stuff, if you are willing to share this kind of information
please mail me.
If you are
going to use this procedure with or without modicfications
please let me know what you think about it, and if there are
point i forgot or that should be determined on an other way. The
way i made i seems right to me, but i could be wrong, or there
could be a better way??
You may
use these scripts if you like them, and you may modify them. I'm
not responsible for the way they are working or any damage they
possibly could do. As always just test them first on a
test-environment before going live. If it works for me it don't
have to work for you!!
Update:
Because the
discussionboard changed so much i have rewritten the SQL Statement
for the parts of the discussionboard, you will find it in the added
SQL Script Course_Summary_7.sql
Sincerely
Jos Jans
jja @ stoas.nl |
