5,889
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE ts11(TTDCTO VARCHAR(20), TTDOCO VARCHAR(20), TTKCOO VARCHAR(20), TTLNID VARCHAR(20), TTCFGPID INT, TTDS01 VARCHAR(20))
insert ts11 SELECT 'S9' ,'80001181', '00100', '11000', 0 ,NULL
union all select 'S9' ,'80001181', '00100', '11000', 1 ,'脚'
union all select 'S9' ,'80001181', '00100', '11000', 1 ,NULL
union all select 'S9' ,'80001181', '00100', '11000', 1 ,'板'
union all select 'S9' ,'80001181', '00100', '11000', 1 ,NULL
union all select 'QO' ,'50032192', '00100', '1000', 0 ,NULL
union all select 'QO' ,'50032192', '00100', '1000', 1 ,'脚'
union all select 'QO' ,'50032192', '00100', '1000', 1 ,'脚'
CREATE FUNCTION f_ts11(@TTDCTO VARCHAR(20),@TTDOCO VARCHAR(20), @TTKCOO VARCHAR(20), @TTLNID VARCHAR(20))
RETURNS VARCHAR(100)
BEGIN
DECLARE @sql VARCHAR(100)
SELECT @sql=ISNULL(@sql+',','')+TTDS01
FROM ts11
WHERE TTDCTO=@TTDCTO AND TTDOCO=@TTDOCO AND TTKCOO=@TTKCOO AND TTLNID=@TTLNID AND TTCFGPID=1
AND ISNULL(TTDS01,'')<>''
RETURN @sql
END
UPDATE ts11 SET TTDS01=dbo.f_ts11(TTDCTO,TTDOCO, TTKCOO, TTLNID)
WHERE TTCFGPID=0
SELECT * FROM ts11