DECLARE @a int, @Finterid int, @Fdayid int SELECT @Finterid = MAX(Finterid),
@Fdayid = MAX(Fdayid)
FROM t_MutiWorkCal
SET @a = 0 WHILE (@a < 365) BEGIN
INSERT
INTO t_MutiWorkCal(FInterID, FDay, FDayID, FWeekID, FMonthID, FYearID, FCalID,
FPreID, FNxtID, FPreDay, FNxtDay)
SELECT @Finterid, CONVERT(datetime, '2013-05-01') + @a, @Fdayid, 157,
37, 4, 999, @Finterid, @Finterid, CONVERT(datetime, '2013-05-01')
+ @a, CONVERT(datetime, '2013-05-01') + @a
SET @a = @a + 1
SET @Finterid = @Finterid + 1
SET @Fdayid = @Fdayid + 1
END
插入多工厂日历表
原创
©著作权归作者所有:来自51CTO博客作者stkingdee的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章