Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rowjie
Starting Member
2 Posts |
 Posted - 2006-06-13 : 05:59:05
|
I'm currently doing a Reports Module in a project here in the Philippines.One of the reports is from an appointments table, I have to create a 7 Days planner. From the dates in the table, I have to classify each appointment to what day it falls. For example, there's an appointment for June 13, 2006, I have to show in a data grid under the column Tuesday. It would depend on what date the user will choose on when to start the 7 Days Planner.I've been trying several SQL select & join statements but I haven't got the perfect answer. I've tried doing several left joins but still, it isn't the right one.Please help me. I need to finish this within the week.Thanks!  |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
7 Days Planner
Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] 