Returning Records that occur during a given week!

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 2000 Forums

SQL Server Development (2000)

Returning Records that occur during a given week!

Author

Topic

Nick
Posting Yak Master

155 Posts

Posted - 2001-11-02 : 10:42:14

I'd like to write a select statement that returns records within a week given one day in that week. For example if I know the date is 11/2/2001 I want all records returned between 10/28/2001 and 11/3/2001. How would I go about doing this?

Thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources