Xtykutl

I need to derive columns from the row values of one column.

Here's the row data.

CustomerID  Activity    Date

10001       Active      2018-06-21

10001       Inactive    2018-06-25

10001       Active      2018-08-22

10001       Inactive    2018-10-06

And here's the output that I am trying to get to:

CustomerID  ActiveDate      InactiveDate

10001       2018-06-21      2018-06-25

10001       2018-08-22      2018-10-06

Please help! Thanks!

You can try to make row number in subquery group by CustomerID,Activity, then do condition aggregate function.

SELECT CustomerID,

       MAX(CASE WHEN Activity = 'Active' THEN Date END) ActiveDate,

       MAX(CASE WHEN Activity = 'Inactive' THEN Date END) InactiveDate

FROM (

    SELECT *,ROW_NUMBER() OVER(PARTITION BY CustomerID,Activity ORDER BY Date ) rn

    FROM T

)t1

group by CustomerID,rn

sqlfiddle

You logic is a little unclear. If you want the next "inactive" date:

select CustomerID, date as active_date, inactive_date

from (select t.*,

             min(case when activity = 'Inactive' then date end) over (partition by CustomerID order by date desc) as inactive_date

      from t

     ) t

where activity = 'Active';