DECLARE @Count int
DECLARE @chvCKMRefID nvarchar(50)
DECLARE @intAccountID int;

DECLARE dublicate_cursor CURSOR FAST_FORWARD FOR
SELECT chvCKMRefID, intAccountID, Count(*) - 1
FROM Account_Professional_Information
WHERE intAccountID = 194
GROUP BY chvCKMRefID, intAccountID
HAVING Count(*) > 1

OPEN dublicate_cursor

FETCH NEXT FROM dublicate_cursor INTO @chvCKMRefID, @intAccountID, @Count

WHILE @@FETCH_STATUS = 0
BEGIN

DELETE TOP(@Count) FROM Account_Professional_Information WHERE chvCKMrefID = @chvCKMRefID AND intAccountID = @intAccountID

FETCH NEXT FROM dublicate_cursor INTO @chvCKMRefID, @intAccountID, @Count
END

CLOSE dublicate_cursor
DEALLOCATE dublicate_cursor