I have a view where I have the following type of information
user_id, username, checkin_time, checkin type, checkin_#, date, location
These are currently showing in rows of each user's checkin appearing on a new row, generally each user has 4 checkins per day. The location is also the same for each date, they never change the location.
I would like to alter or pivot my results to show each checkin a user has per a particular day. For instance it would appear
userid date username location checkin_time 1, checkin_time 2, checkin_time 3, checkin_time 4
1 5/18/2011 USERNAME! home 8 AM 12PM 1 PM 6 PM
Is there an easy way to translate my current date to the output I'm seeking.
View Complete Post