where后面怎么用case.when

declare @t table(bu_no int,bs_no int,uc_no int,us_no int)insert into @t select d.bu_no,c.bs_no,b.uc_no,a.us_no from KT_U_Student as a inner join KT_U_Class as b on a.uc_no=b.uc_noinner join KT_B_Special as c on b.bs_no=c.bs_noinner join KT_B_Unit as d on c.bu_no=d.bu_nowhere a.us_no=1128select * from @tselect b.ola_no,c.olar_no,    convert(varchar(10),b.ola_date,120) as period_date,    convert(varchar(5),c.olar_starttime,114)+'—'+convert(varchar(5),c.olar_endtime,114) as period_time,    case ola_type when 1 then '学生自拟' when 2 then '指定课题' when 3 then '指定项目' end as ola_itemtype,    case ola_isappseat when 1 then '是' when 0 then '否' end as ola_appseat,    case ola_isexam when 1 then '是' when 0 then '否' end as ola_exam,    ola_maxperson,(select count(*) from KT_EXO_LabAppPerson where olar_no=c.olar_no) as yyy_numfrom KT_EXO_LabApplication as a inner join KT_EXO_LabTimePeriod as b on a.ol_no=b.ol_no inner join KT_EXO_LabArrangement as c on b.ola_no=c.ola_nowhere 1=1 and a.ol_no=1 and ol_islevel=2 [color=#FF0000][b]--我想让只有当b.ola_openobj=2的时候才进行下面判断,应该怎么做?[/b][/color]and (    (select count(*) from KT_EXO_LabOpenObj where olobj_type=1 and ola_no=b.ola_no and olobj_id=(select bu_no from @t))>0    --学院    or (select count(*) from KT_EXO_LabOpenObj where olobj_type=2 and ola_no=b.ola_no and olobj_id=(select bs_no from @t))>0    --专业    or (select count(*) from KT_EXO_LabOpenObj where olobj_type=3 and ola_no=b.ola_no and olobj_id=(select uc_no from @t))>0    --班级    or (select count(*) from KT_EXO_LabOpenObj where olobj_type=4 and ola_no=b.ola_no and olobj_id=(select us_no from @t))>0    --学生)

--没有数据，不能测试，写法是可行的and (    case when b.ola_openobj=2 then (select count(*) from KT_EXO_LabOpenObj where olobj_type=1 and ola_no=b.ola_no and olobj_id=(select bu_no from @t)) end>0    --学院    or     case when b.ola_openobj=2 then (select count(*) from KT_EXO_LabOpenObj where olobj_type=2 and ola_no=b.ola_no and olobj_id=(select bs_no from @t)) end>0    --专业    or     case when b.ola_openobj=2 then (select count(*) from KT_EXO_LabOpenObj where olobj_type=3 and ola_no=b.ola_no and olobj_id=(select uc_no from @t)) end>0    --班级    or     case when b.ola_openobj=2 then (select count(*) from KT_EXO_LabOpenObj where olobj_type=4 and ola_no=b.ola_no and olobj_id=(select us_no from @t)) end>0    --学生)--你试试下面这种写法declare @t table(bu_no int,bs_no int,uc_no int,us_no int)insert into @t select d.bu_no,c.bs_no,b.uc_no,a.us_no from KT_U_Student as a inner join KT_U_Class as b on a.uc_no=b.uc_noinner join KT_B_Special as c on b.bs_no=c.bs_noinner join KT_B_Unit as d on c.bu_no=d.bu_nowhere a.us_no=1128select * from @tif  ol_islevel=2 beginselect b.ola_no,c.olar_no,    convert(varchar(10),b.ola_date,120) as period_date,    convert(varchar(5),c.olar_starttime,114)+'—'+convert(varchar(5),c.olar_endtime,114) as period_time,    case ola_type when 1 then '学生自拟' when 2 then '指定课题' when 3 then '指定项目' end as ola_itemtype,    case ola_isappseat when 1 then '是' when 0 then '否' end as ola_appseat,    case ola_isexam when 1 then '是' when 0 then '否' end as ola_exam,    ola_maxperson,(select count(*) from KT_EXO_LabAppPerson where olar_no=c.olar_no) as yyy_numfrom KT_EXO_LabApplication as a inner join KT_EXO_LabTimePeriod as b on a.ol_no=b.ol_no inner join KT_EXO_LabArrangement as c on b.ola_no=c.ola_nowhere 1=1 and a.ol_no=1 and (    (select count(*) from KT_EXO_LabOpenObj where olobj_type=1 and ola_no=b.ola_no and olobj_id=(select bu_no from @t))>0    --学院    or (select count(*) from KT_EXO_LabOpenObj where olobj_type=2 and ola_no=b.ola_no and olobj_id=(select bs_no from @t))>0    --专业    or (select count(*) from KT_EXO_LabOpenObj where olobj_type=3 and ola_no=b.ola_no and olobj_id=(select uc_no from @t))>0    --班级    or (select count(*) from KT_EXO_LabOpenObj where olobj_type=4 and ola_no=b.ola_no and olobj_id=(select us_no from @t))>0    --学生)end