Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
Join the community of 500,000 technology professionals and ask your questions.