title: DML Trigger in SQL Server
body: <p>This is my code </p>
  
  <pre><code>ALTER TRIGGER [CoSD].[BusinessLogicUtilTrigger] 
  ON [CoSD].[ERSConstructedVariablesOutcomes]
  AFTER INSERT, UPDATE
  AS
      ;WITH dataforIDs AS
      (
          SELECT 
              value, ERSBusinessLogic_InputDataSeries
          FROM  
              [AnimalProductsCoSD].[CoSD].[ERSBusinessLogic]
          CROSS APPLY
              (SELECT
                   Seq = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),
                   Value = v.value('(./text())[1]', 'VARCHAR(MAX)')
               FROM
                   (VALUES (CONVERT(XML, '&lt;x&gt;' + replace(ERSBusinessLogic_InputDataSeries,',','&lt;/x&gt;&lt;x&gt;')+'&lt;/x&gt;'))) x(n)
          CROSS APPLY
              n.nodes('x') node(v)) B
          WHERE
              ERSBusinessLogic_InputGeographyDimensionID = 7493
              AND ERSBusinessLogic_InputTimeDimensionValue = 'all months'
              AND ERSBusinessLogic_Type = 'HS10 aggregation'
      )
  </code></pre>
  
  <p>Is there any way to modify this trigger that it calls after a stored procedure completes its execution. Right now I feel it is called as soon one row is inserted.</p>
  
  <p>In short I want a trigger which will call after the stored procedure is executed OR is there any way else to achieve this ?</p>