手工输入金蝶凭证号自动补号的SQL脚本
服务热线：400-665-0027
新购有特价、金蝶老客户升级金蝶云产品可以享受5折优惠，送手机、送话费，好礼不断！
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
SELECT @FNumber=ISNULL(MAX(FIndex), 0)+1 FROM #tmp;
ELSE
SELECT @FNumber=ISNULL(MIN(t.FIndex), 0)
FROM #tmp AS t
WHERE t.FIndex
DROP TABLE #tmp;
SELECT @FNumber;