|
Here's a Stored procedure shared by Pramod which might help
code
update m_savings_account_transaction sat1 join (select @row_num := if(@prev_value=sat.savings_account_id and @prev_date = sat.transaction_date,@row_num+1,1) AS RowNumber, @prev_value := sat.savings_account_id as accId, @prev_date := sat.transaction_date as transactionDate,sat.id as id from m_savings_account_transaction sat where sat.created_date = sat.transaction_date order by sat.savings_account_id DESC,sat.transaction_date,sat.transaction_type_enum = 3 DESC, sat.transaction_type_enum = 1 DESC, sat.transaction_type_enum = 2 DESC, sat.id) x on x.id = sat1.id set sat1.created_date = TIMESTAMPADD(SECOND,x.RowNumber,sat1.transaction_date)
{{code}
|
