MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
select parent_id, parent_desc, contract_id, pg.group_desc as Tier_Desc, ca.actdate as mdf_date, ca.stat, volume from select * into Dashboard.dbo.test_temp from openquery(MyDb,' (SELECT l.PROV_id, l.prov_name, tp.parent_id, tp.parent_desc, lob.lob_id, lob.lob_desc, l.provider_category_desc, max(s.provider_key) provider_key, max(s.s_contract_key) s_contract_key, SUM(Case when S.month_key in (2010307, 2010308, 2010309, 2010410) then S.VOLUME_PAID else 0 end) AS volume FROM " bunch of tables here but not icluded in here" AND S.MONTH_KEY >= 2010307 and S.MONTH_KEY <= 2011206 GROUP BY 1,2,3,4,5,6) f left outer join (select lca.provider_key, lca.s_contract_key, lca.price_group_key, lca.activation_date, lca.status from osr_price_act_content lca where lca.provider_key <> 0 group by lca.provider_key, lca.s_contract_key, lca.price_group_key, lca.activation_date, lca.status) ca on f.provider_key = ca.provider_key and f.s_contract_key = ca.s_contract_key left outer join lookup_price_group pg on pg.price_group_key = ca.price_group_key ')
Add your voice to the tech community where 5M+ people just like you are talking about what matters.