Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LEFT JOIN
- (SELECT
- o.Opportunity_RecID
- ,o.Opportunity_Name
- --,COUNT(a.last_Updated_utc) As TimesSetToClosedStatus
- ,MIN(a.last_updated_utc) As Date_SAL
- FROM
- [dbo].v_rpt_Opportunity o
- INNER JOIN [dbo].SO_Opportunity_Audit a ON a.Opportunity_RecId = o.Opportunity_RecID
- INNER JOIN [dbo].SO_Opportunity_Audit_Value av ON a.SO_Opportunity_Audit_RecId = av.SO_Opportunity_Audit_RecId
- INNER JOIN [dbo].Audit_Type at ON at.Audit_Type_RecId = a.Audit_Type_RecId
- WHERE
- at.Audit_Type_ID = 'Stage' AND audit_token = 'new_value' AND CONVERT(int,LEFT(av.audit_value,1)) >= 4
- GROUP BY
- o.Opportunity_RecID, o.Opportunity_Name
- ) Stage_SAL ON Stage_SAL.opportunity_recid = o.opportunity_recid
Add Comment
Please, Sign In to add comment