34,575
社区成员
发帖
与我相关
我的任务
分享
ALTER FUNCTION [dbo].[fn_GetJobContainerCntNo]
(@JobNo varchar(20))
RETURNS varchar(250)
AS
BEGIN
DECLARE @STEMP VARCHAR(250)
SELECT @STEMP=ISNULL(@STEMP+',','')+ISNULL(CNTNo,'')
from
(SELECT DISTINCT CNTNO FROM BIZ.JOBCONTAINER WHERE parentJOBNO=@JobNo)T
RETURN @STEMP
END
ALTER FUNCTION [dbo].[fn_GetJobContainerCntNo]
(@JobNo varchar(20))
RETURNS varchar(250)
AS
BEGIN
DECLARE @STEMP VARCHAR(250)
SELECT @STEMP=''
SELECT @STEMP=@STEMP+ ISNULL(CNTNo,'')
from
(SELECT DISTINCT CNTNO FROM BIZ.JOBCONTAINER WHERE parentJOBNO=@JobNo)T
RETURN @STEMP
END
ALTER FUNCTION [dbo].[fn_GetJobContainerCntNo]
(@JobNo varchar(20))
RETURNS varchar(250)
AS
BEGIN
DECLARE @STEMP VARCHAR(250)
SELECT @STEMP=''
SELECT @STEMP=@STEMP+ ISNULL(CNTNo,'')+','
from
(SELECT DISTINCT CNTNO FROM BIZ.JOBCONTAINER WHERE parentJOBNO=@JobNo)T
RETURN @STEMP
END