title: TSQL set concatenating varchar during cursor
body: <p>When debugging, @buildEvents gets filled the first time it enters the loop but then never gets concatenated the next time around.  Is this possible inside of a cursor?</p>
  
  <pre><code>OPEN @BusinessCursor;
  FETCH NEXT FROM @BusinessCursor INTO  @BusinessName;
  
  WHILE @@FETCH_STATUS = 0
  BEGIN
  
  set @buildEvents = @buildEvents + @BusinessName
  
  FETCH NEXT FROM @BusinessCursor INTO   @BusinessName;
  END
  
  CLOSE @BusinessCursor;
  DEALLOCATE @BusinessCursor;     
  
  
        select @buildEvents
        return
  </code></pre>
  
  <p>Any ideas on how to get @buildEvents concatenated with @BusinessName?  The data im passing through is html data for an email.  </p>