發展遲緩的中年人

避免老年癡呆，趕快記下來。

declare @colname varchar(200)

 SELECT  @colname = STUFF(( SELECT 

                                '],[' + t2.vcolumndef

                        FROM EC.tb_trclass_subjectitemdef   AS t2

                        where vtype = '3' and nsubjectno = 1

                        ORDER BY '],[' +  t2.vcolumndef

                        FOR XML PATH('')

                      ), 1, 2, '') + ']'

 print @colname                       

 declare @a varchar(1000)

 set @a = 'SELECT * from

            (select * from EC.tb_trclass_subjectitem_a  where nsubjectno = 1  and vtype =''3'') src

           PIVOT (count(vlink) FOR vcolumndef IN ('+@colname+')) AS pvt'             

    EXEC (@a)