Here is an example of a recursive CTE: DECLARE @Date DATETIME SELECT @Date = '20120308 11:00:00' ;WITH Dates AS ( SELECT DATEPART(HOUR,DATEADD(HOUR,-1 ...
確定! 回上一頁