Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL LOOP Dates

Status
Not open for further replies.
LeighDreyer

LeighDreyer

Programmer
Mar 4, 2003
16
0
0
GB
I have a GPCT_CALENDAR table which has one Field TODAYS_DATE
it stores 10 years worth of dates. I have a start_date and an end_date Parameter. I have another table which holds patient details and lists appointments with Their Appointment Date. For each date period (Start_Date and End_Date) I need to count For each day how many appointments there are against each Calendar_Day in that period.

Not sure how to do this anyone ?.
 
Status
Not open for further replies.

Similar threads

spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
132
dhookom
dhookom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
142
Swi
Swi
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
78
serino
serino
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
84
dhookom
dhookom
dw134
  • Locked
  • Question
Working with SQL
Replies
2
Views
33
BrooksR
BrooksR

Part and Inventory Search

Sponsor

Back
Top