This is my Table
This is my table data.
| 27 | 2011-05-30 00:00:00.000 | 2011-05-31 00:00:00.000 | 2011-05-30 00:00:00.000 | meeting | description | Violet | CornflowerBlue | NULL | NULL | 1 | 6 PM | 8 PM | Guntur |
| 28 | 2011-06-05 00:00:00.000 | 2011-06-07 00:00:00.000 | 2011-06-01 00:00:00.000 | discussion | meeting | SteelBlue | Beige | 1 | 1 | 1 | 4 PM | 5 PM | Hyderabad |
Just concentrate these columns i.e EventStartDate,EventEndDate,StartTime and EndTime.
I am selecting EventStartDate,EventEndDate,StartTime and EndTime.
So two records are available in the table.
Next time I am selecting EventStartDate,EventEndDate,StartTime and EndTime
Suppose data present between the dates and timings It has to return the data otherwise doesn't return.
I want that Query.