June 12, 2013 at 3:10 am
Hi All,
I have two parameters start and endweek which shows the measure column weekly from Monday -until sunday
.
Say
13/05 --- value 100
20/05 -- value 200
27/05 -- value 300
But I need the query to be added weekly with another column commencing from April 1st 2013 until Endweek
Week Total
13/05/2013 13/05/2013 weeks value + Week commnecing april 1st 2013 until May 12ths value
20/05/2013 20/05/2013 weeks value +Week commnecing april 1st 2013 until May 19ths value
27/05/2013 27/05/2013 weeks value +Week commnecing april 1st 2013 until May 26ths value
any help pls? thankks
June 12, 2013 at 6:10 am
In order to have any chance at helping you out here, I'm going to you to post the DDL, some DML to populate some data and your expected results. For guidance on how to do this, Jeff Moden has an excellent article to help you out: http://qa.sqlservercentral.com/articles/Best+Practices/61537.
June 12, 2013 at 9:04 am
Have a look at the dateadd()-function.
For more detailled answer, as Ed Wagner said, more details are required.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply