Winston Churchill was a Data Analyst

"However beautiful the strategy, you should occasionally look at the results." -Winston Churchill

Script I used to populate DimDate from AdventureWorks with current data

WITH mycte AS
    (
    SELECT CAST('2012-01-01' AS DATETIME) DateValue
        UNION ALL
    SELECT DateValue + 1
        FROM mycte
        WHERE DateValue + 1 < '2013-12-31'
    )INSERT INTO dimdate
    SELECT CONVERT(VARCHAR, DateValue, 112) AS DateKey
            , CAST(DateValue AS date) AS FullDateAlternateKey
            , DATEPART(dw, datevalue) AS DayNumberOfWeek
            , [dbo].[FormatDateTime] (DateValue, '[dweek]') AS DayNameOfWeek
            , dbo.FormatDateTime(DateValue, '[d]') AS DayNumberOfMonth
            , DATEPART(dy, datevalue) AS DayNumberOfYear
            , DATEPART(ww, datevalue) AS WeekNumberOfYear
            , dbo.FormatDateTime(DateValue, '[MONTH]') AS MonthName
            , dbo.FormatDateTime(DateValue, '[M]') AS MonthNumberOfYear
            , DATEPART(q, datevalue) AS CalendarQuarter
            , DATEPART(yyyy, datevalue) AS CalendarYear
    FROM mycte
            OPTION (MAXRECURSION 0)

I'll include a new script that will populate the other tables with good dates some time later.

Quote on Business Failure

"I can't give you a surefire formula for success, but there is one for failure: Try to please everybody all the time." Herbert Bayard Swope

Thomas Edison Believes in Iterations, Too!

"I have not failed. I've just found 10,000 ways that won't work." -Thomas Edison

Hugh Prather speaking to Agilists

"It's simple: if I never try anything, I never learn anything."-Hugh Prather

Quote for Agilists

Salman Rushdie speaking to agilists: "A bit of this and a bit of that is how newness enters the world."

Quote

"If one FELT successful, there'd be so little incentive to BE successful." Alain de Botton