Get a new requirement about take process using time from DMS system.
it's easy to use known row to get time between two status which has field in DB.
but, not everyone status has been recorded with a field.I need take the status from log files.
My PM told me use cursor and temp tables.alright, that very slow. but no body care about that I think.
In fact, None of true data are standard. people will use DMS flow thires mind, but not process. so ,when I process data, i feel...... tired.
Mission complete:
1.get time between status Submit and investigate
2.get time between status submit and assign
3. between ready for test and test ok/failed
need finished tomorrow:
get time between rejected and closed/other status.
你可以使用这个链接引用该篇文章 http://publishblog.blogchina.com/blog/tb.b?diaryID=6571456