Hi Mahmoud What do you want your query to do? Andy Hoang TEL Systems Manager UWL From: Blackboard/Courseinfo userslist [mailto:[log in to unmask]] On Behalf Of Mahmoud S Sent: 07 December 2015 17:10 To: [log in to unmask] Subject: Help with MSSQL Query Hi All, I am seeking your help to make sure that the below query correct or i need to modify it. SELECT cm.course_id ,gm.title 'Test name' ,ca.external_window_ind 'Opened in a new window (Y) or not (N)' ,ca.force_completion_ind as 'ForceComplete' ,ca.delivery_type_ind 'Questions are delivered. A=All at once, Q=One question at a time' ,ca.randomize_questions_ind 'Randomized questions' ,ca.multiple_attempts_ind 'Multiple Attempted' ,ca.attempt_count'attempts allowed when multiple_attempts_ind is set to Y' ,ca.unlimited_attempts_ind 'Unlimited times attempted' ,ca.allow_late_submission_ind 'Late submissions are allowed' ,ca.time_limit 'Time limit completion in minutes' ,ca.timer_completion 'Continual (C) or Hardstop (H)' ,ca.show_score_ind 'Score is shown' ,ca.show_correct_ans_ind 'Correct answer is shown' ,ca.show_user_ans_ind 'submitted answer is shown' ,ca.password_ind 'Require Password ' ,qad.bbmd_assessmenttype from gradebook_main gm , qti_asi_data qad , course_main cm , course_assessment ca where qad.pk1=gm.qti_asi_data_pk1 and qad.crsmain_pk1=cm.pk1 and qad.pk1=ca.qti_asi_data_pk1 and cm.course_id like 'fall_2015_[a-z]%' order by course_id Regards, Mahmoud