Hi,
I am using Rad Recurrence control Q3 version on the web form .
We are saving Recurrence rule as string in our table .
Our requirement is to build a SQL function which will read the recurrence rule and count the recurrences for the start and end period.
e.g, for below rule , find the how many times it will occur in the present week ?
we have created assembly for ExpandRecurrence_UDF.dll as per the http://www.telerik.com/community/forums/aspnet-ajax/scheduler/sql-reporting-display-all-recurring-appointments.aspx page in SQL.
But dont know how to use other get occurence count using ExpandRecurrence_UDF.dll .
Pls let us know how we can achieve this using SQL function ?
Thanks,
Dipti
I am using Rad Recurrence control Q3 version on the web form .
We are saving Recurrence rule as string in our table .
Our requirement is to build a SQL function which will read the recurrence rule and count the recurrences for the start and end period.
e.g, for below rule , find the how many times it will occur in the present week ?
DTSTART:
20000101T000000Z DTEND:20000102T000000Z RRULE:FREQ=DAILY;COUNT=3;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
we have created assembly for ExpandRecurrence_UDF.dll as per the http://www.telerik.com/community/forums/aspnet-ajax/scheduler/sql-reporting-display-all-recurring-appointments.aspx page in SQL.
But dont know how to use other get occurence count using ExpandRecurrence_UDF.dll .
Pls let us know how we can achieve this using SQL function ?
Thanks,
Dipti
1 Answer, 1 is accepted
0
Hello Dipti,
Please take a look at this help article for a guide to your requirement.
P.S: Please do not open more than one thread per issue. We are doing our best to answer all your questions.
Kind regards,
Veronica Milcheva
the Telerik team
Please take a look at this help article for a guide to your requirement.
P.S: Please do not open more than one thread per issue. We are doing our best to answer all your questions.
Kind regards,
Veronica Milcheva
the Telerik team