Try the below SQL Query -
DECLARE @TranDate DATETIME = '02/23/2013 12:00:00 AM', -- new date time for the duplicate records
@Amount MONEY,
@EvolutionCreditAccount VARCHAR(MAX),
@EvolutionDebitAccount VARCHAR(MAX),
@Id INT = 1,
@MaxId INT
DECLARE @TEMPTABLE TABLE (Id INT IDENTITY(1,1),TranDate DATETIME, Amount MONEY, EvolutionCreditAccount NVARCHAR(MAX), EvolutionDebitAccount NVARCHAR(MAX), Completed BIT)
INSERT @TEMPTABLE
SELECT * FROM temp
WHERE Completed = 1
SELECT @MaxId = MAX(Id) FROM @TEMPTABLE
WHILE @Id <= @MaxId
BEGIN
SELECT
@Amount = Amount,
@EvolutionCreditAccount = EvolutionCreditAccount,
@EvolutionDebitAccount = EvolutionDebitAccount
FROM @TEMPTABLE
WHERE Id = @Id
INSERT INTO Temp
(
TranDate,
Amount,
EvolutionCreditAccount,
EvolutionDebitAccount,
Completed
)
VALUES
(
@TranDate,
@Amount,
@EvolutionCreditAccount,
@EvolutionDebitAccount,
1
)
SET @Id = @Id + 1
END