title: T-SQL cursor not producing expected output
body: <pre><code>GO
  SET NOCOUNT ON;
  
  DECLARE
  @idAdvertisements int,
  @Name nvarchar(255),
  @Description nvarchar(500),
  @DepartureDate datetime,
  @Cities_idCities int,
  @Areas_idAreas int,
  @Countries_idCountries int,
  @Agencies_idAgencies int,
  @Url nvarchar(1000),
  @Price decimal(6, 2),
  @HollidayDuration int,
  @BookingDate datetime;
  
  DECLARE ad_cursor CURSOR
     FOR SELECT idAdvertisements
               ,Name
               ,Description
               ,DepartureDate
               ,Cities_idCities
               ,Areas_idAreas
               ,Countries_idCountries
               ,Agencies_idAgencies
               ,Url
               ,Price
               ,HollidayDuration
               ,BookingDate
        FROM Advertisements;
  
  OPEN ad_cursor;
  FETCH NEXT FROM ad_cursor
  INTO @idAdvertisements
      ,@Name
      ,@Description
      ,@DepartureDate
      ,@Cities_idCities
      ,@Areas_idAreas
      ,@Countries_idCountries
      ,@Agencies_idAgencies
      ,@Url
      ,@Price
      ,@HollidayDuration
      ,@BookingDate;
  
  WHILE @@FETCH_STATUS = 0
  BEGIN
     PRINT ' ';
     PRINT @idAdvertisements;
     --PRINT @Name;
     --PRINT @Description;
     --PRINT @DepartureDate;
     --PRINT @Cities_idCities;
  
  END
  CLOSE ad_cursor; 
  </code></pre>
  
  <p>But I always get <code>1, 1, 1, 1, 1</code>. Data are always the same.</p>
  
  <p><code>SELECT</code> statement is OK. I don't understand why. Can someone see the problem?</p>