Guest User

Untitled

a guest
Nov 1st, 2024
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.72 KB | None | 0 0
  1. LEFT JOIN
  2.         (SELECT
  3.             o.Opportunity_RecID
  4.             ,o.Opportunity_Name
  5.             --,COUNT(a.last_Updated_utc) As TimesSetToClosedStatus
  6.             ,MIN(a.last_updated_utc) As Date_SAL
  7.         FROM
  8.             [dbo].v_rpt_Opportunity o
  9.             INNER JOIN  [dbo].SO_Opportunity_Audit a ON a.Opportunity_RecId = o.Opportunity_RecID
  10.             INNER JOIN [dbo].SO_Opportunity_Audit_Value av ON a.SO_Opportunity_Audit_RecId = av.SO_Opportunity_Audit_RecId
  11.             INNER JOIN [dbo].Audit_Type at ON at.Audit_Type_RecId = a.Audit_Type_RecId
  12.         WHERE
  13.             at.Audit_Type_ID = 'Stage' AND audit_token = 'new_value' AND CONVERT(int,LEFT(av.audit_value,1)) >= 4  
  14.  
  15.         GROUP BY
  16.             o.Opportunity_RecID, o.Opportunity_Name
  17.         ) Stage_SAL ON Stage_SAL.opportunity_recid = o.opportunity_recid
Add Comment
Please, Sign In to add comment