Cacher is the code snippet organizer for pro developers

DECLARE @heid uniqueidentifier
DECLARE @heitemid uniqueidentifier
DECLARE @hepropcmpsid uniqueidentifier
DECLARE @hecmpsid uniqueidentifier
DECLARE db_cursor CURSOR FOR
SELECT
  heid,
  heitemid,
  hecmpsid
FROM heretailentrylines

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @heid, @heitemid, @hecmpsid

WHILE @@FETCH_STATUS = 0
BEGIN

  SELECT
    @hepropcmpsid = hepropcmpsid
  FROM heitems
  WHERE heid = @heitemid
  IF NOT (@hepropcmpsid IS NULL)
    AND (@hecmpsid IS NULL)
  BEGIN
    UPDATE heretailentrylines
    SET hecmpsid = @hepropcmpsid
    WHERE heid = @heid
  END


  FETCH NEXT FROM db_cursor INTO @heid, @heitemid, @hecmpsid
END

CLOSE db_cursor
DEALLOCATE db_cursor