I don't think this is possible in one SQL statement.
What you might try is creating one SQL-statement for every day and then join the data of all the statements together.


>I try to build the following result:
>

>Employee    Monday 1/1     Tuesday 2/1    Wednesday 3/1  Thurs 4/1 ...
>---------------------------------------------------------------------
>Jaime       BA123 10:00     BA123 10:00     BA123 10:30   LY111 16:30
>            LY111 16:30                     LY111 16:30
>

>
>I did this through a manual loop through the table, but i'd like to do it through SQL if possible, so any ideas will be greatly appreciated.
>
>In the meantime, a happy and productive new year to all
>Jaime