title: loop through data in sql server trigger
body: <p>I have a sql-server trigger which does a select at the begining. That select returns hundreds of rows, and I want to loop those rows. How can I loop the returned data?</p>
  
  <p>here is my trigger, I want to loop @ProfId</p>
  
  <pre><code>Create TRIGGER EmailQueueRaw_Control_Trigger ON EmailQueueRaw FOR INSERT
  AS
  BEGIN
     SELECT @ProfId= ProfessionalID,@Email= Email from Professionals 
  END
  </code></pre>
  
  <p>How can I loop @ProfId?</p>