摘要：SELECT CASEWHEN BeginDate > MonthStart THEN BeginDate ELSE MonthStart ENDAS BeginDate, CASEWHEN EndDate < MonthEnd THEN EndDate ELSE MonthEnd ENDAS EndDate, … /* other columns as needed */FROM( SELECT d.*, /* or you could be more specific here */ ( DATEADD(month, DATEDIFF(month,0, d.BeginDat.. 阅读全文