问从天数定义周的SQL

EN

DECLARE @tbl TABLE(DateValue VARCHAR(8),OtherValue INT);
INSERT INTO @tbl VALUES
 ('30-09-15',10)
,('29-09-15',20)
,('28-09-14',30)
,('28-08-14',10)
,('27-08-14',10);


SELECT CONVERT(DATETIME,DateValue,3) AS ConvertedDate
        ,DATEPART(WK,CONVERT(DATETIME,DateValue,3)) AS WeekIndex
        ,OtherValue 
FROM @tbl

--And this is the way to use this for aggregates
;WITH MyData AS
(
    SELECT CONVERT(DATETIME,DateValue,3) AS ConvertedDate
            ,DATEPART(ISO_WEEK,CONVERT(DATETIME,DateValue,3)) AS WeekIndex
            ,OtherValue 
    FROM @tbl   
)
SELECT WeekIndex,SUM(OtherValue)
FROM MyData
GROUP BY WeekIndex