年度變號新增作業

最新推荐文章于 2023-01-04 14:41:07 发布

jaxkxu

最新推荐文章于 2023-01-04 14:41:07 发布

阅读量498

点赞数

分类专栏： ESON SQLServer 文章标签： date table insert

本文链接：https://blog.youkuaiyun.com/jaxkxu/article/details/7180093

版权

ESON 同时被 2 个专栏收录

38 篇文章

订阅专栏

SQLServer

13 篇文章

订阅专栏

INSERT INTO BAS.VOUCHER_INFO
--SELECT * FROM BAS.VOUCHER_INFO
SELECT TABLE_COLUMN,0,LIMIT_NUM,DELTA_NUM,SN_LEN,SUBSTRING(PREFIX_NO,1,2) + '12'+SUBSTRING(PREFIX_NO,5,1),SUFFIX_NO
,DATEADD(yyyy,1,START_DATE),DATEADD(yyyy,1,END_DATE)
FROM BAS.VOUCHER_INFO WHERE TABLE_COLUMN LIKE 'OAS.FORM_INFO.FORM_NO_1001%' 
AND START_DATE BETWEEN '2011-01-01' AND '2011-12-31'

INSERT INTO BAS.VOUCHER_INFO
SELECT TABLE_COLUMN,0,LIMIT_NUM,DELTA_NUM,SN_LEN,SUBSTRING(PREFIX_NO,1,2) + '12'+SUBSTRING(PREFIX_NO,5,1),SUFFIX_NO
,DATEADD(yyyy,1,START_DATE),DATEADD(yyyy,1,END_DATE)
FROM BAS.VOUCHER_INFO WHERE TABLE_COLUMN LIKE 'OAS.FORM_INFO.FORM_NO_1001%' 
AND START_DATE BETWEEN '2011-01-01' AND '2011-12-31'