简单写了一个手工输入凭证号,自动补号的SQL脚本
DECLARE @FNumber INT,@fstartnumber INT ;
SET @fstartnumber=900
SELECT ROW_NUMBER() OVER (ORDER BY FNumber)+@fstartnumber-1 AS FIndex, a.FNumber
INTO #tmp
FROM(SELECT FNumber
FROM t_Voucher
WHERE FYear=2020 AND FPeriod=7 AND FGroupID=1
UNION
SELECT FNumber
FROM t_VoucherBlankOut
WHERE FYear=2020 AND FPeriod=7 AND FGroupID=1) a WHERE a.FNumber>=@fstartnumber;
IF NOT EXISTS (SELECT * FROM #tmp AS t WHERE t.FIndex<t.FNumber)
SELECT @FNumber=ISNULL(MAX(FIndex), 0)+1 FROM #tmp;
ELSE
SELECT @FNumber=ISNULL(MIN(t.FIndex), 0)
FROM #tmp AS t
WHERE t.FIndex<t.FNumber;
DROP TABLE #tmp;
SELECT @FNumber;
简单写了一个手工输入凭证号,自动补号的SQL脚本
DECLARE @FNumber INT,@fstartnumber INT ;SET @fstartnumber=900SELECT ROW_NUMBER() OVER (ORDER BY FNumber)+@fstartnumber-1...
点击下载文档
本文2024-09-16 17:05:59发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-13518.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章