|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi ALL,
I have a problem with one of the ouputs from a table.
The table looks like this: due_date events count(due_date) 4/5/2005 Affina 1 4/5/2005 Ionics 1 4/5/2005 Ultimate 1 5/5/2005 Dresser 1 5/5/2005 First 1 6/5/2005 Ofoto 1 I want the table to look like this: Due_date Slot1 Slot2 Slot3 4/5/2005 Affina Ionics Ultimate 5/5/2005 Dresser First NULL 6/5/2005 Ofoto NULL NULL Can somebody please help me on how to get the resultatnt table using a SQL Query. Or if any suggestions on how i have to go about this. Thanks Madhavan Bangalore INDIA |
|
#2
|
|||
|
|||
|
this is not to realize in a simple query. I think you have to write a little more complex procedure or script to get out this result from your table.
what database do you use? |
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > Hi ALL, |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|