手工输入金蝶凭证号自动补号的SQL脚本

售后技术专线：4006-6500-28

新购有特价、金蝶老客户升级金蝶云产品可以享受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;