Query

[sarang_k]

Hi all, I created a table in which there r n fields and in that two of them are date field i.e., startdate and enddate. Now i want to write a query,to fetch the records from table which comes under startdate and enddate. so,i need a help how to write the query. Thanks in advance.

[Blue_Boy]

What you did so far? Have you try to write a query? As I could understood you then query should be like: select startdate,enddate from mytable where startdate >'2009.12.01' and enddate > '2009.12.22'

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[Niladri_Biswas]

Try this

declare @t table(somevalue varchar(100),startdate datetime, enddate datetime)
insert into @t
select 'somevalue1','01/14/2009', '01/20/2009' union all
select 'somevalue2','01/15/2009', '01/22/2009' union all
select 'somevalue3','01/18/2009', '01/31/2009' union all
select 'somevalue4','02/01/2009', '02/10/2009' union all
select 'somevalue5','05/14/2009', '05/20/2009'

I want to get the records where between '01/14/2009' and '02/01/2009' (inclusive) Query:

select * from @t
where startdate >='01/14/2009' and enddate <='02/01/2009'

Output: somevalue startdate enddate

somevalue1 2009-01-14 00:00:00.000 2009-01-20 00:00:00.000
somevalue2 2009-01-15 00:00:00.000 2009-01-22 00:00:00.000
somevalue3 2009-01-18 00:00:00.000 2009-01-31 00:00:00.000

:)

Niladri Biswas