SET NOCOUNT ON -- SQL Server 2000 USE ProfilerTest; GO UPDATE a SET TextData = 'Not Applicable2' FROM dbo.ProfilerResults3 a INNER JOIN dbo.ProfilerResults3 b ON a.RowNumber = b.RowNumber WHERE a.RowNumber = b.RowNumber AND a.EventClass = b.EventClass AND a.ApplicationName = b.ApplicationName; GO SELECT * FROM dbo.ProfilerResults3; GO