表结构
需要从meeting和meeting_sign表得到下面这个表
SQL语句
我放的临时表
create table #tmp(
flag_userid nvarchar(max),
flag_no_userid nvarchar(max)
)
DECLARE @i int = 1
DECLARE @j int = 1
WHILE @i <= (select count(id) from meeting)
begin
insert into #tmp(flag_userid,flag_no_userid)
select ( select stuff((
select ','+CONVERT(varchar(10),userid) from meeting_sign left join meeting m on m.id=meetingid where flag='Y'and m.id=@i
for xml path('')),1,1,'') )as flag_userid,
( select stuff((
select ','+CONVERT(varchar(10),userid) from meeting_sign left join meeting m on m.id=meetingid where flag='N'and m.id=@i
for xml path('')),1,1,'') )as flag_no_userid
SET @i = @i + 1
end
select * from #tmp
drop table #tmp