SET NOCOUNT ON -- SQL Server 2005 USE ProfilerTest; GO UPDATE a SET TextData = 'Not Applicable' FROM dbo.ProfilerResults3 a WHERE a.RowCheckSum = CHECKSUM(RowNumber, EventClass, ApplicationName); GO SELECT * FROM dbo.ProfilerResults3; GO