SQL查找缺少的日期范围

您可以使用CTE并通过以下方式编写查询：

declare @StartDate DATE, @EndDate DATEset @StartDate = '2013-09-01';set @EndDate = '2013-09-30';  WITH DateRange(Date) AS     (         SELECt  @StartDate Date         UNIOn ALL         SELECT  DATEADD(day, 1, Date) Date         FROM  DateRange         WHERe  Date < @EndDate     )     SELECt 'webshop',Date      FROM DateRange     EXCEPT      SELECt DataSet,DateRange     FROM importedDateRange     WHERe DataSet='webshop'     --You could remove Maximum Recursion level constraint by specifying a MaxRecusion of zero     OPTION (MaxRecursion 10000);