34,575
社区成员
发帖
与我相关
我的任务
分享
IF NOT OBJECT_ID('f') IS NULL
DROP TABLE f
GO
CREATE TABLE f([FC_XM] NVARCHAR(20),[FC_XMMC] NVARCHAR(18),[FC_XMJC] INT)
INSERT f
SELECT N'00000000000000000001',N'合计',1 UNION ALL
SELECT N'ZDY0001',N'同级次合计',2 UNION ALL
SELECT N'00000000000000000017',N'重点产品',3 UNION ALL
SELECT N'00000000000000003507',N'严迪(罗红霉素分散片)(75mg)',4 UNION ALL
SELECT N'00000000000000003540',N'颠茄磺苄啶片(成人10片)',4 UNION ALL
SELECT N'00000000000000003499',N'小儿氨酚黄那敏颗粒',4 UNION ALL
SELECT N'00000000000000003501',N'严迪(罗红霉素分散片)(50mg)',4 UNION ALL
SELECT N'00000000000000003498',N'小儿氨酚黄那敏颗粒(20袋/盒)',4 UNION ALL
SELECT N'00000000000000003436',N'哈药六牌钙加锌口服液(80盒/箱)',4 UNION ALL
SELECT N'00000000000000003506',N'严迪(罗红霉素分散片)(150mg)',4
GO
SELECT * FROM f
select FC_XM, replicate(' ',FC_XMJC)+FC_XMMC,FC_XMJC from F