Home » SQL & PL/SQL » SQL & PL/SQL » Pivot
Pivot [message #250953] Thu, 12 July 2007 00:38 Go to next message
vamsi88
Messages: 6
Registered: January 2007
Junior Member
Hi,

I've data like this..

CASE_ID ACTION DT
1227626 Assigned case to FixerGroup 17.05.2007
1227626 Case Note 18.05.2007
1227626 Assigned case to FixerGroup 18.05.2007
1227626 Case Note 22.05.2007
1227626 Assigned case to FixerGroup 23.05.2007
1227626 Case Note 24.05.2007
1227626 Assigned case to FixerGroup 24.05.2007
1227626 Case Note 25.05.2007

Is there a way i can display my data like this:

CASE_ID DT_Received DT_Actioned
1227626 17.05.2007 18.05.2007
1227626 18.05.2007 22.05.2007
1227626 23.05.2007 24.05.2007
1227626 24.05.2007 25.05.2007

i.e where
Action ="Assigned case to FixerGroup" DT should become the DT_Received
and where
Action= "Case Note " DT should become the DT_Actioned

Thanks
Vamsi

Re: Pivot [message #250954 is a reply to message #250953] Thu, 12 July 2007 00:40 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
you just did the transformation, so problem is solved!
Re: Pivot [message #250956 is a reply to message #250954] Thu, 12 July 2007 00:43 Go to previous messageGo to next message
vamsi88
Messages: 6
Registered: January 2007
Junior Member
anacedent,

Sorry i didnt understand what you are trying to say ....

Thanks
Vamsi

Re: Pivot [message #250966 is a reply to message #250953] Thu, 12 July 2007 01:33 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put your title in the search field and you get your answer.

Regards
Michel
Previous Topic: message displaying
Next Topic: problem on associative array
Goto Forum:
  


Current Time: Wed Dec 07 20:47:49 CST 2016

Total time taken to generate the page: 0.09923 seconds