Title: Message Title
|
|
|
|
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} }
|
|
|
|
|
|
|
|
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
