Qurey related

Question

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.