存储过程参数问题求教
select a.*,b.groupno,c.Title,d.KeyPath from AUTH_Answer a right join AUTH_Answer_Access b on a.Answer_ID=b.Answer_ID left join AUTH_GROUP c on b.groupno =c.groupno left join SchoolWork d on a.WorkID = d.WorkID
where b.groupno in ('+GroupNO+') and a.WorkID=d.WorkID
and
datepart(yy,a.Answer_InputDate)=@NowYear
and
datepart(m,a.Answer_InputDate)=@NowMonth
order by c.Title,a.Answer_InputDate desc
现在我的这个GroupNO可能是一个组,也可能是多个组,如果是多个组,传进来的值为"aa,bb,cc"
请问我怎么实现这里where b.groupno in ('aa','bb','cc')?