Count of Path sequency

[srinivasa1]

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.

[srinivasa1]

Hi

has any idea how we can achive this one pls help me.waiting for some

Solution

Thanks in advance.