Mahesh Babu

Mahesh Babu

  • NA
  • 1.7k
  • 367.1k

Qurey related

May 19 2011 4:03 AM
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.
 

Answers (22)