INSERT INTO #date (SaleOrderDate,produceLineID,branchDepID,controlTypeID) SELECT convert(varchar(10),dateadd(dd,number,'2019-10-8'),120), bpi.produceLineID, 10000,1 from master..spt_values,dbo.baseProduceLineInfo bpi where type='p' and number <= datediff(dd,'2019-10-8','2019-10-18') AND bpi.produceLineID = 6
拆分时间(比如2019-10-1到2019-10-9的拆分成9条数据)
最新推荐文章于 2024-06-28 15:03:39 发布