I’ve a requirement to schedule a recursive event with DHTMLX and once user scheduled the event, other user can search by date to see if he is available on this date/time.
I’m able to save to database the recursive events without any issue. Now say user#1 scheduled an event and it’s stored in database as below.
Start date:- 2015-03-11 10:00:00.000
End Date:- 9999-02-01 00:00:00.000
Rec Type:- week_2___1,3,5#no
Now user#2 want to see if 2015-03-14 user#1 is available. how to run SQL query to get these details? I’m using sql server 2008 to build my project. can anyone please help.