select fiscal_quarter, count(*) as Count
from [WW TIER_1] with (nolock)
group by fiscal_quarter
order by fiscal_quarter
select count(*) from [WW TIER_1] where fiscal_quarter < 'FY15Q1' --1940933
Select * into [Archive_WW TIER_1_17072017]
from [WW TIER_1] where fiscal_quarter < 'FY15Q1'
select count(*) from [Archive_WW TIER_1_17072017]
delete from [WW TIER_1] where fiscal_quarter < 'FY15Q1'
select count(*) from [WW TIER_1] where fiscal_quarter >= 'FY15Q1' --2381934
select * from DIM_BA_PRODUCT_REF
