To Calvin Lawson - I should hav added the modified code as follows:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE SP_TEST01

AS

BEGIN

SET NOCOUNT ON;

if object_ID('dbo.TBLTEST01') is not null drop table TBLTEST01

CREATE TABLE TBLTEST01(

ID int identity Not NUll Primary Key,

CustNum int NOT NULL,

PostedDate datetime NOT NULL,

PaymentAmt money NOT NULL,

PaymentMemo varchar(200) NOT NULL,

CCRefNum char(10) NOT NULL

)

Insert TBLTEST01 Values (1, '01/10/2004', 1, '', '')

Insert TBLTEST01 Values (1, '01/11/2004', 1, 'Keep', '')

Insert TBLTEST01 Values (2, '01/10/2004', 2, '', '')

Insert TBLTEST01 Values (2, '01/11/2004', 2, '', '')

Insert TBLTEST01 Values (2, '01/12/2004', 2, 'Keep', '')

Insert TBLTEST01 Values (3, '01/10/2004', 3, '', '')

Insert TBLTEST01 Values (3, '01/11/2004', 3, '', '')

Insert TBLTEST01 Values (3, '01/12/2004', 3, '', '')

Insert TBLTEST01 Values (3, '01/13/2004', 3, 'Keep', '')

delete p1

From TBLTEST01 p1

JOIN TBLTEST01 p2

on p1.CustNum = p2.CustNum and

p1.PostedDate < p2.PostedDate and

p1.PaymentAmt = p2.PaymentAmt

where p1.ID < p2.ID

END

Thanks again