I need to create a table which shows days of the week. Data is from Database.
Team Sun Mon Tue Wed Thur Fri Sat
Headers are static.
Based on current date, (11/25/2010) which is a "Thurs" day, this data should come in Thurs field and all the before days should calculate automatically based on that respective date. Fri & Sat should be empty as no data will be there in the database.
If the current date is Sun, then rest of the data should be blank.
Pls guide me to write a query which will do this function.