Hi,
Can any guide me i can achive same path(Msg status) sequence followed for MessageKey (ie1,2) and(3,4)
i need report on message followed same path and duration for each msg status a (ie time diffrence between sent,Queuied for msgkey1)
MessageKey Msg Status Msgdate
1 Sent 10/16/2012 9:00
1 Queued 10/16/2012 10:00
1 Open 10/16/2012 11:00
1 Msg Expired 10/16/2012 0:00
2 Sent 10/16/2012 9:00
2 Queued 10/16/2012 10:00
2 Open 10/16/2012 11:00
2 Msg Expired 10/16/2012 0:00
3 Sent 10/16/2012 9:00
3 Inprocess 10/16/2012 10:00
3 SENT TO VENDOR 10/16/2012 11:00
4 Sent 10/16/2012 9:00
4 Inprocess 10/16/2012 10:00
4 SENT TO VENDOR 10/16/2012 11:00
Appreciate your inputs.
