create view production.aggregated_accounting_period_view as
SELECT periodid, perioddate, quarter, quarter_integer
  FROM 
  (

      SELECT periodid,
             CAST(CAST(YEAR AS VARCHAR(4)) + RIGHT ('0' + CAST(MONTH AS VARCHAR(2)),2) + '01' AS DATETIME)
                AS perioddate,
             year + '-' + 'Q' + quarter AS quarter,
             CAST(quarter AS integer)   AS quarter_integer
      FROM production.dim_period
  );