4/06/2011

Disable enrollments of all students for FA2010 (course_users)

update cu
SET row_status = '2'
FROM course_users cu
INNER JOIN course_main cm ON cu.crsmain_pk1 = cm.pk1
INNER JOIN users u ON cu.users_pk1 = u.pk1
WHERE cm.course_id LIKE '%FA2010%' AND
course_users.data_src_pk1 < '20' AND u.user_id not like 'stu_%' AND
u.user_id not like '%student%' AND u.user_id not like '%faculty%' AND
u.user_id <> 'bross' AND
u.user_id NOT LIKE 'temp-olw%' AND cu.role = 'S' AND
u.institution_roles_pk1 = '1'

No comments:

Post a Comment