SQL以日期动态更新维护的数据,一周排程时间日期

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

以维护日期的不同而改变显示内容.如今天是21号.维护了七天的 数据即21--28.当在22号打开维护界面的时候,维护内容显示为22--29号的 数据以及日期.
创建维护表:..

-----------------创建 数据记录表-------------------------

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[Pdl_WeekProcedure]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

droptablePdl_WeekProcedure

GO 

ifnotexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[Pdl_WeekProcedure]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

 BEGIN

       CreateTablePdl_WeekProcedure(

       [Id]intIdentity(1,1)NotNull,

       [DateId]datetimeNotNull,

       [Partnum]varchar(20)Null,

       [Revision]varchar(5)NullDEFAULT('0'),

       [Todate]datetimeNull,

       [Qnty1]intNullDefault(0),

       [Qnty2]intNullDefault(0),

       [Qnty3]intNullDefault(0),

       [Qnty4]intNullDefault(0),

       [Qnty5]intNullDefault(0),

       [Qnty6]intNullDefault(0),

       [Qnty7]intNullDefault(0)--,

--    [WeekDate]datetime

       CONSTRAINT[PK_WeekProcedure]PRIMARYKEY CLUSTERED

       (

               [Id]

       ) ON[PRIMARY]

   )ON[PRIMARY]

 

End

 -----------------创建日期表--------------------

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[Pdl_WeekProcedureDate]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

droptablePdl_WeekProcedureDate

GO

 ifnotexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[Pdl_WeekProcedureDate]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

 BEGIN

       CreateTablePdl_WeekProcedureDate(

       [Id]intIdentity(1,1)NotNull,

       [DateId]datetimeNotNull,

       [Date1]datetimeNull,

       [Date2]datetimeNull,

       [Date3]datetimeNull,

       [Date4]datetimeNull,

       [Date5]datetimeNull,

       [Date6]datetimeNull,

       [Date7]datetimeNull

       CONSTRAINT[PK_WeekProcedureDate]PRIMARYKEY CLUSTERED 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>