help with date ranges - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

help with date ranges

Author

Topic

lfelipe
Starting Member

2 Posts

Posted - 2009-04-16 : 23:00:19

Hello All,

How would I bring in the following record if the date range criteria is to bring in anything falls between '01/01/2008' and '12/31/2008'?

RECORD A
StartDate = 2006-01-01
EndDate = 2009-01-31

I'm sure it's something really simply but I can't seem to figure this one out.

Thank you in advance for any advice/help.

kunal.mehta
Yak Posting Veteran

83 Posts

Posted - 2009-04-17 : 02:18:11

Hi,

declare @table1 table (date datetime,Agrid int,chkId int,name varchar(18) )

insert into @table1 values('01/01/2008',102252271,100061, 'abc')
insert into @table1 values('12/31/2008',102252271,100842, 'Eli OldName')
insert into @table1 values('11-11-2004',102252271,100843, 'Eli OldName') ;
select * from @table1 where date between '01/01/2008' and '12/31/2008'

Kunal

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-17 : 03:41:50

If date column has time too

select * from @table1
where date >='20080101' and date<'20090101'

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-17 : 10:45:36

[code]select * from @table1
where startdate <='12/31/2008' and enddate>='01/01/2008'
[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources