组合的ID 如 22614,22601,22582
拆开后 就是3个分别的ID ,用这3个ID可以查询出3条数据,下面的方法就是用SQL把ID对应多条数据的名称再拼接成字符串
-- 列转行,教室合并成字符串 获取字符串
--列转行,主讲合并成字符串
declare @ClassRoomName varchar(100)
SELECT @ClassRoomName=STUFF((SELECT ','+MainDemoName FROM OLAPschoolRoomDim where ','+@ClassRoomIDSName+',' like +'%,'+convert(varchar,OLAPKey) +',%' FOR XML PATH('')),1,1,'')
--列转行,主讲合并成字符串
declare @LecTeaName varchar(100)
SELECT @LecTeaName=STUFF((SELECT ','+MainDemoName FROM OLAPAgentDim where ','+@LecTeaIDSName+',' like +'%,'+convert(varchar,OLAPKey) +',%' FOR XML PATH('')),1,1,'')
--列转行,辅讲合并成字符串
declare @InsTeaName varchar(100)
SELECT @InsTeaName=STUFF((SELECT ','+MainDemoName FROM OLAPAgentDim where ','+@InsTeaIDSName+',' like +'%,'+convert(varchar,OLAPKey) +',%' FOR XML PATH('')),1,1,'')