/****** Script for SelectTopNRows command from SSMS ******/

select * from(

select [CLASS_CODE],[CLASS_NAME] FROM [dbo].[SYSTEM_DICT] s where s.DICT_CODE = 'Week'

) a

PIVOT

(

count(a.[CLASS_CODE]) for a.[CLASS_NAME] in([星期一],[星期二],[星期三],[星期四],[星期五],[星期六],[星期日])

)b

select

[CLASS_CODE],

[CLASS_NAME] ,

STUFF(',',1,1,(

select [CLASS_NAME]+',' from [SYSTEM_DICT]

where DICT_CODE = s.DICT_CODE

for xml path('')

)

) as Names

FROM [dbo].[SYSTEM_DICT] s where s.DICT_CODE = 'Week'