-- 888888888888888888888888

-- 1 - Compare each column in order to perform the update
SET NOCOUNT ON

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



-- 2 - Compare the checksum value to perform the update
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

