sqlserver text类型的列怎么转行？

sqlserver text类型的列怎么转行？
select fymc,BRZD,BRXB,HZNL,FYSL,YYTS,YLDW,SYPC,YFMC,HIS_YPBM,
(case when DMMC='药品用量审查' then cast(GZXX AS varchar(max)) else GZXX end )as '药品用量审查' ,
(case when DMMC='剂量限制' then cast(GZXX AS varchar(max)) else GZXX end )as '剂量限制' ,
(case when DMMC='成药草药相互作用' then GZXX else GZXX end )as '成药草药相互作用' ,
(case when DMMC='成药相互作用' then GZXX else GZXX end )as '成药相互作用' ,
(case when DMMC='抗生素重复用药' then GZXX else GZXX end )as '抗生素重复用药' ,
(case when DMMC='特殊人群之特殊年龄审查' then GZXX else GZXX end )as '特殊人群之特殊年龄审查' ,
(case when DMMC='性别限制' then GZXX else GZXX end )as '性别限制' ,
(case when DMMC='药物禁忌症审查' then GZXX else GZXX end )as '药物禁忌症审查' ,
(case when DMMC='注射药物配伍审查' then GZXX else GZXX end )as '注射药物配伍审查' ,
(case when DMMC='药物相互作用审查' then GZXX else GZXX end )as '药物相互作用审查'  from


 (
SELECT
        c.DMMC,
        CASE WHEN cast(A.GZXX_TSXX  AS varchar(4000))IS NULL OR LEN(CAST(A.GZXX_TSXX AS VARCHAR(4000))) <= 0 THEN A.GZXX ELSE CAST( A.GZXX_TSXX as varchar(4000))END GZXX,
        cast(A.FYMC as varchar(1000))as fymc ,
       dbo.f_strMzzd(A.YSJZXH,A.HGSJ) BRZD,
       A.BRXB,
       A.HZNL,
       A.FYSL,
       A.YYTS,
       A.DCYL,
       A.YLDW,
       A.SYPC,
       f.YFMC,
       A.HIS_YPBM  
FROM  BJYB_HGJL_MZ A,
      BJYB_YBGZ B LEFT JOIN BJYB_SJZD C ON C.DMSB = B.GZLBM AND C.DMLB = '100'
      ,dbo.BJYB_FYHG_MZ_CFXX d  ,dbo.BJYB_YPXX_YPYF  f ,dbo.BJYB_FYHG_MZ_MZZD e
WHERE A.GZBM = B.GZBM

and a.CFHM=d.CFHM and a.HIS_YPBM=d.HIS_YPBM  and d.YPYF=f.YPYF
and a.ysjzxh=e.ysjzxh
AND
      
      ( ( A.HGSJ >= '2019-9-27 0:0:0.000' And
          A.HGSJ <= '2019-9-29 23:59:59.000' And
          1 = 1
        ) Or
        ( A.JYRQ >= '2019-9-27 0:0:0.000' And
          A.JYRQ <= '2019-9-29 23:59:59.000' And
          1 = 2
        )
      ) And
      (A.GZBM LIKE '0' + '%' OR '0' = '0') And
      ((A.SHBZ = '0' And '0' = '0') oR
       (A.SHBZ > '0' And '0' = '1') OR
       '0' = '-1'
      ) And
      (A.KSBM = '-1' Or '-1' = '-1') AND
      (0 = 0 Or
        ( 0 = 1 And
          A.BRXZLX in (SELECT XZBM FROM V_YBFX_BRXZ)
        )
      )

 
    ) a
   

case wehn 中的GZXX这个字段就是text类型的，用case转的话，case转的行的值都是一样的。