hi,
i am looking for script which give how many time P_ID is change from green to red in a month..
My source table look like
Date P_ID Status
1 jan 2012 1 Green
2 jan 2012 1 Green
3 jan 2012 1 RED
4 jan 2012 1 Green
5 jan 2012 1 Green
6 jan 2012 1 RED
7 jan 2012 1 RED
8 jan 2012 1 RED
.........
1 Feb 2012 2 Green
2 Feb 2012 2 Green
3 Feb 2012 2 RED
4 Feb 2012 2 RED
5 Feb 2012 2 Green
6 Feb 2012 2 Green
........
and output which i need look lke
Month P_ID count of Change to Red
Jan 2012 1 2
Feb 2012 2 1
thanks
