It looks like you have some tables with the schedule information and all that you want is to get the schedules for each week. So, do you want some help with the t-sql query so that you can display it appropriately? If yes, then I will need the table structures to help you.
Or is it that you want to display it in a SSRS report?
Either ways, you have to give me more information on what is your source data structures, and what you would like the end result to be? And what are the toolset that you are trying to achieve it in.
commented on Jun 20 2012 8:56AM