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转的行的值都是一样的。
