Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

iSAMS Courses to Moodle View

jonwitts Jun 24th, 2014 226 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. SELECT DISTINCT
  2.         TblSubjects.txtSubjectName,
  3.         TblSets.txtSetCode AS txtCourseID,
  4.         (TblSubjects.txtSubjectName + ' - ' + TblSets.txtSetCode) AS txtFullName,
  5.         (TblSubjects.txtSubjectName + ' - ' + TblSets.txtSetCode) AS txtShortName,
  6.        
  7.         CASE TblSubjects.txtSubjectName
  8.                 WHEN 'Academic Extension' THEN 6
  9.                 WHEN 'Art' THEN 16
  10.                 WHEN 'Arabic' THEN 29
  11.                 WHEN 'Art Photography' THEN 22
  12.                 WHEN 'Art Textiles' THEN 17
  13.                 WHEN 'Biology' THEN 11
  14.                 WHEN 'Business Studies' THEN 15
  15.                 WHEN 'Chemistry' THEN 12
  16.                 WHEN 'Chinese' THEN 30
  17.                 WHEN 'Classics' THEN 34
  18.                 WHEN 'Drama' THEN 18
  19.                 WHEN 'Economics' THEN 15
  20.                 WHEN 'English' THEN 27
  21.                 WHEN 'English as an Additional Language' THEN 28
  22.                 WHEN 'English Language' THEN 27
  23.                 WHEN 'English Literature' THEN 27
  24.                 WHEN 'Film Studies' THEN 19
  25.                 WHEN 'Fine Art' THEN 16
  26.                 WHEN 'Food Technology' THEN 21
  27.                 WHEN 'French' THEN 29
  28.                 WHEN 'Further Mathematics' THEN 23
  29.                 WHEN 'Geography' THEN 25
  30.                 WHEN 'German' THEN 29
  31.                 WHEN 'Greek' THEN 31
  32.                 WHEN 'Gym' THEN 33
  33.                 WHEN 'Health Education' THEN 33
  34.                 WHEN 'History' THEN 26
  35.                 WHEN 'History of Art' THEN 20
  36.                 WHEN 'Hockey' THEN 33
  37.                 WHEN 'Home Economics' THEN 21
  38.                 WHEN 'Lacrosse' THEN 33
  39.                 WHEN 'Latin' THEN 31
  40.                 WHEN 'Learning Support' THEN 37
  41.                 WHEN 'Mandarin' THEN 30
  42.                 WHEN 'Mathematics' THEN 23
  43.                 WHEN 'Music' THEN 32
  44.                 WHEN 'Netball' THEN 33
  45.                 WHEN 'Philosophy & Ethics' THEN 36
  46.                 WHEN 'Physical Education' THEN 33
  47.                 WHEN 'Physics' THEN 13
  48.                 WHEN 'Politics' THEN 35
  49.                 WHEN 'Religious Studies' THEN 36
  50.                 WHEN 'Science' THEN 10
  51.                 WHEN 'Spanish' THEN 29
  52.                 WHEN 'Sport' THEN 33
  53.                 WHEN 'Swimming' THEN 33
  54.                 WHEN 'Textiles Technology' THEN 17
  55.                 WHEN 'Theatre Studies' THEN 18
  56.                 ELSE 8
  57.         END AS intCategoryID
  58.        
  59. FROM            
  60.         TblTeachingManagerSets AS TblSets
  61.         INNER JOIN TblTeachingManagerSubjects AS TblSubjects ON TblSets.intSubject = TblSubjects.TblTeachingManagerSubjectsID
  62.  
  63. WHERE
  64.         (TblSubjects.txtSubjectName <> 'Private Study')
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top