Hvala na brzom odgovoru.
U principu mi treba da sve podatke vrati mysql iz jednog upita jer upit koristim u JasperReports-u.
Sto se tice takvog resenja koje od sledecih resenja bi MySql to bolje podnosio:
1. 31 dodatni select kao npr:
Code:
select distinct b.USER_ID `user`, year(a.ENTRY_DATE) `y`, month(a.ENTRY_DATE) `m`, b.PROJECT_ID `project`,
(select a1.HOURS from TIMESHEET_ENTRY a1 where a1.ENTRY_DATE=concat(`y`,'-',`m`,'-','01') and a1.ASSIGNMENT_ID=a.ASSIGNMENT_ID) `d1`,
(select a1.HOURS from TIMESHEET_ENTRY a1 where a1.ENTRY_DATE=concat(`y`,'-',`m`,'-','02') and a1.ASSIGNMENT_ID=a.ASSIGNMENT_ID) `d2`,
...
...
(select a1.HOURS from TIMESHEET_ENTRY a1 where a1.ENTRY_DATE=concat(`y`,'-',`m`,'-','30') and a1.ASSIGNMENT_ID=a.ASSIGNMENT_ID) `d30`,
(select a1.HOURS from TIMESHEET_ENTRY a1 where a1.ENTRY_DATE=concat(`y`,'-',`m`,'-','31') and a1.ASSIGNMENT_ID=a.ASSIGNMENT_ID) `d31`
from TIMESHEET_ENTRY a
join PROJECT_ASSIGNMENT b on a.ASSIGNMENT_ID = b.ASSIGNMENT_ID;
2. Uvodjenjem "vestacke" Calendar tabele, npr svi datumi od 2000-2030 i pravljenjem outer join-a sa tom tabelom.
3. ili da se kreira zeljeni output iz stored procedure sa koriscenjem temp tabele
Hvala,
Igor