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 proposal.proposal_id,proposal.proposal_rev,prospect.prospect_name,proposal.crt_ts,proposal.proposal_eff_end_dt, SUM(ISNULL(proposal_ln.ln_final_extd_price, 0)) as final_extd_price,(ROW_NUMBER() OVER (ORDER BY proposal.crt_ts desc)) AS RecID FROM [dbo].[proposal] INNER JOIN prospect on proposal.prospect_id=prospect.prospect_id LEFT OUTER JOIN proposal_ln ON proposal.proposal_id=proposal_ln.proposal_id and proposal.proposal_rev=proposal_ln.proposal_rev WHERE proposal.prmry_sls_prsn = 'SALES' AND proposal.crt_ts > DATEADD(dd,-30,getDate()) and proposal.proposal_stat_cd IN ('INCP','REDY','DLVD','EXPD') and ISNULL(proposal_ln.ln_stat_cd,'D') <> 'DLTD' GROUP BY proposal.proposal_id ,proposal.proposal_rev ,prospect_name ,proposal.crt_ts ,proposal.proposal_eff_end_dt ,stat.stat_desc
Join the community of 500,000 technology professionals and ask your questions.