Guys, Not sure if this is possible but I am gonna ask away and see where I get.
I would like to be able to create a matrix of employees and there holidays in a query that can easily show who is on holiday at any point in time the paramaters are the start_date and End_Date then what it would do is create the columns that are between the parameters what the table would show is:-
parameter 1 = Start date 01/06/2015
parameter2 = End date 30/06/2015
=====These are static=== ===================dynamically created============================
Employee, Emp_No,office, 01/06/2015,02/06/2015,03/06/2015..........28/06/2015, 29/06/2015, 30/06/2015
the first 3 columns are static and will always show.
Any ideas on how to do this as I undesrtand in oracle 11g I could use a PIVOT function but as this is Oracle 10g that's not an option.