用存储过程吧Create Procedure sp_unregisterdate @startdate, @enddate
As
Declare @tmpdate DateTime
Create Table #DateTable(DateColumn DateTime)
Select @tmpdate = @startdate
While @tmpdate <= @enddate
Begin
If Not Exists(Select * From table1 Where word_date = @tmpdate)
Insert Into @DateTable Values(@tmpdate)
Select @tmpdate = DateAdd(Day, 1, @tmpdate)
End
Select * From @DateTable
As
Declare @tmpdate DateTime
Create Table #DateTable(DateColumn DateTime)
Select @tmpdate = @startdate
While @tmpdate <= @enddate
Begin
If Not Exists(Select * From table1 Where word_date = @tmpdate)
Insert Into @DateTable Values(@tmpdate)
Select @tmpdate = DateAdd(Day, 1, @tmpdate)
End
Select * From @DateTable
select Everyday from compareTable where Every not in (select Work_Date from Talbe1) and EveryDay>=DateStart and EveryDay<=DateEnd