Hi there,
I'm having troubles creating reports with T-SQL having a table with recurrent appointments which off course only has the base appointments and possible exceptions.
Is there any SQL-code available to 'expand' the appointments within SQL using the stored recurrence-info?
The only other option would be to get the records from the database, expand them within an application and save the expanded records back to the database, where I could use them to create the reports. That sounds like a hassle?
Thank you for any tips!