如何自动生成 每天单据断号情况，谢谢

1、我这样写，在SQL里能查到一天的断号情况，单据号是以日流水的，如何按日自动生成断号表？谢谢

DECLARE @MINID INT,@MAXID INT,@GOINT INT,@DDATE DATE
select @DDATE='2019-7-11'
SELECT @MINID = MIN(replace(cDLCode,'ASH','')),@MAXID = MAX(replace(cDLCode,'ASH','')) FROM DispatchList
where year(ddate)=2019 and ddate=@DDATE

SET @GOINT = @MINID
SELECT @GOINT AS GOID INTO #LSTAB
WHILE @GOINT < @MAXID BEGIN
SET @GOINT = @GOINT + 1
INSERT INTO #LSTAB(GOID) VALUES (@GOINT)
END

SELECT '发货单号' as 单据,GOID as 断号 FROM #LSTAB
WHERE GOID NOT IN (
SELECT replace(cDLCode,'ASH','') FROM DispatchList where year(ddate)=2019 and ddate=@DDATE
)
ORDER BY GOID

DROP TABLE #LSTAB