Where子句- Between Condition错误

Question

我正试图在我的查询下面工作，我有大部分的权利，但由于某种原因，我的BETWEEN条件不工作，当试图过滤掉数据集…它根本不会过滤。谁能看看我下面的代码，让我知道我做错了什么…或者甚至建议一种替代方法来过滤掉从7月到9月底的记录?

SELECT  A.[Name] AS ResourceName,
    A.[ID] AS ResourceID,
    CONVERT(VARCHAR(10),A.[STRT_Date],101) AS StartDate,
    CONVERT(VARCHAR(10),A.[END_Date],101) AS EndDate,
    CASE WHEN A.[END_Date] > A.[STRT_Date] THEN C2.[DY_OF_CAL_NUM] - C1.[DY_OF_CAL_NUM] 
         WHEN A.[END_Date] IS NULL and A.[STRT_Date] IS NOT NULL THEN C3.[DY_OF_CAL_NUM] - C1.[DY_OF_CAL_NUM]
         WHEN A.[END_Date] = A.[STRT_Date] THEN 1
    END AS AgeCalendar
FROM    [Report] AS A       
    INNER JOIN [Dim] AS B 
    ON A.[ID] = B.[ID]  
    LEFT JOIN [dbo].[DT_DIM] AS C1 
    ON CAST(A.STRT_Date AS DATE) = C1.[CAL_DT]      
    LEFT JOIN [dbo].[DT_DIM] AS C2 
    ON CAST(A.END_Date AS DATE) = C2.[CAL_DT]       
    LEFT JOIN [dbo].[DT_DIM] AS C3 
    ON CAST(GETDATE() AS DATE) = C3.[CAL_DT]
WHERE   1 = 1
AND     A.[STRT_Date] BETWEEN '07/01/2016' AND '09/30/2016'
AND     A.[Name] like '%S-Info%'
OR      A.[Name] like '%S-Dep%'
OR      A.[Name] like '%S-Can%' 
OR      A.[Name] like '%S-Doc%'

Answer 1

用()包裹Or操作符:

WHERE A.[STRT_Date] BETWEEN '07/01/2016' AND '09/30/2016'
AND (A.[Name] like '%S-Info%'
     OR A.[Name] like '%S-Dep%'
     OR A.[Name] like '%S-Can%' 
     OR A.[Name] like '%S-Doc%')

当前发生的情况是，如果一个记录的Name与'%S-Doc%'相似，即使它不在日期之间，它也将被选中。通过包装有效Name的所有变体，您说它必须介于日期和"以下条件之一"之间