SQL-Weekly data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL-Weekly data

SQL-Weekly data

Rate Topic

Display Mode

Topic Options

Author

Message

var05

Posted Thursday, December 20, 2012 5:54 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:13 AM
Points: 83, Visits: 362

Hi All,

I have 2 date parameters say :

Calendar Start Date - 08/15/2012
Calendar End Date - 08/22/2012

I wanted to retrieve results of all the days i.e from Aug 13th - 19
and Aug 20th - 26th

say my sql table shld look like

Week Startday-Mon

08/13 - it shld contain data for thaht entire week from 13-19

08/20 -from 20-26

what ever date I select in custom calendar start n end date, the where clause should filter in such a way that display data weekly from the selected parameters.

Any help?

Post #1398931

eklavu

Posted Friday, December 21, 2012 1:43 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 1:33 AM
Points: 51, Visits: 146

here is a good link http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

Once you get the first day of the week add no of days to that with the dateadd function to get the last day of your report.

Post #1399268

« Prev Topic | Next Topic »

Permissions