Hi All,
I'm having a bit of trouble coming to terms with the Scheduler control, in particular performing database queries.
I currently have a stored procedure in which I'm attempting to find the next available time slot (of 30 minutes) which I've managed to do quite simply. However by doing this outside of the scheduler and any application code, I can't (easily) take into account recurrence.
A very simple example of this is:
SELECT *
FROM Appointments
WHERE Start >= @Start
AND End <= @End
***This will give all appointments within the specified range, however it will not return any appointments that occur because of recurrence.
Is there an easy way to query the table I'm storing all appointments only using standard MSSQL functionality?
Any help would be appreciated.
Aidan
I'm having a bit of trouble coming to terms with the Scheduler control, in particular performing database queries.
I currently have a stored procedure in which I'm attempting to find the next available time slot (of 30 minutes) which I've managed to do quite simply. However by doing this outside of the scheduler and any application code, I can't (easily) take into account recurrence.
A very simple example of this is:
SELECT *
FROM Appointments
WHERE Start >= @Start
AND End <= @End
***This will give all appointments within the specified range, however it will not return any appointments that occur because of recurrence.
Is there an easy way to query the table I'm storing all appointments only using standard MSSQL functionality?
Any help would be appreciated.
Aidan
3 Answers, 1 is accepted
0
Hello Aidan,
Please, refer to recurrence Overview and The recurrence engine topics in the help. Also, the topic on
How to display all RadScheduler appointments in GridView might helpful for this case.
If you have any other questions, please feel free to drop us a line.
Regards,
Peter
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Please, refer to recurrence Overview and The recurrence engine topics in the help. Also, the topic on
How to display all RadScheduler appointments in GridView might helpful for this case.
If you have any other questions, please feel free to drop us a line.
Regards,
Peter
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
Aidan
Top achievements
Rank 1
Rank 1
answered on 05 Feb 2008, 10:30 PM
Hi Peter,
Thanks for the prompt response - though I'm not sure you've answered my question.
I have already been through the documentation you linked to, however there's nothing about extracting recurrence without using the recurrence engine, or using the scheduler (as far as I can see anyway!).
I'm wondering if there is anything that could be used to return all appointments using only SQL server? There are a number of reasons for this - but our main concern is that if we have a large number of appointments (going back many years) in our database, then processing one record at a time could be quite time consuming. Doing this inside a stored procedure however - would be considerably faster.
Cheers,
Aidan
Thanks for the prompt response - though I'm not sure you've answered my question.
I have already been through the documentation you linked to, however there's nothing about extracting recurrence without using the recurrence engine, or using the scheduler (as far as I can see anyway!).
I'm wondering if there is anything that could be used to return all appointments using only SQL server? There are a number of reasons for this - but our main concern is that if we have a large number of appointments (going back many years) in our database, then processing one record at a time could be quite time consuming. Doing this inside a stored procedure however - would be considerably faster.
Cheers,
Aidan
0
Accepted
Hi Aidan,
Thanks for clarifying. Due to the way we implement the recurrence concept, what you want to achieve is not possible. Recurrent appointments should be processed one by one.
Regards,
Peter
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Thanks for clarifying. Due to the way we implement the recurrence concept, what you want to achieve is not possible. Recurrent appointments should be processed one by one.
Regards,
Peter
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center