Transpose Row Data into Column based on a criteria

Hi rocky09,

You can write the T-SQL query like below:

SELECT
  *
FROM test0825 t 
CROSS APPLY (SELECT TOP 1
  ActivityID ActivityID_,
  Date Date_,
  InteractionID InteractionID_,
  Type Type_,
  ModifiedBy ModifiedBy_
FROM test0825
WHERE ModifiedBy = 'system'
AND InteractionID = t.InteractionID
AND Date >= t.Date
ORDER BY date ASC) ca
WHERE t.ModifiedBy <> 'system'

If you have any question about T-SQL query, please post a thread in Transact-SQL forum.

Best Regards,
QiuyunYu