Expand Recurrence rule instances

[Costas]

Hi
I am working with RadControlsForAspNetAjaxControlPanel_2012_2_91
and SQLServer 2008 R2.I found the expand recurrence rule demo posted
and i am using it to expand the recurrence rule of appointments.I am using
a windows service that collects the appointments for "execution" every minute.  
In case of an appointment execution failure i need to try to execute again
this appointment as long as there is no other appoinment that is bound to the same resource.
I am trying to get the latest instance from a task for a group but i can't.
e.g This is by Scheduler table containing two recurring appoinments
DTSTART:20121101T103000Z  DTEND:20121101T110000Z  RRULE:FREQ=HOURLY;COUNT=3;INTERVAL=1  for resource 7
DTSTART:20121101T110000Z  DTEND:20121101T113000Z  RRULE:FREQ=HOURLY;COUNT=5;INTERVAL=1 for resource 7
DTSTART:20121101T133000Z  DTEND:20121101T133500Z  RRULE:FREQ=HOURLY;COUNT=2;INTERVAL=1  for resource 8

I use the sql max function for start date but displays me the third instance from the first rule and the fifth instance from the second rule and the second instance from the third rule
Is there any other way to get the latest instance from all instances for a specific resource and for every resource???
(the fifth from second rule and the second from the third rule only)
  

[Plamen]

Hi Vivi,

 
You can retrieve each occurrences (and especially its start time) from a recurrence rule as it is done in this help topic.

hope this will be helpful.

Regards,
Plamen
the Telerik team

[Abhi]

could u please explain it in more details

[Plamen]

Hi Abhi,

 
The Occurrences property or the recurrence rule returns an enumerator that can be used to retrieve all the occurrences defined by the rule. If you need more information please let me know what exactly is not clear so I try to be more helpful.

Greetings,
Plamen
the Telerik team