aspose file tools*
The moose likes JDBC and the fly likes SQL server : How to group by the data by monday to sunday as a week ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL server : How to group by the data by monday to sunday as a week ?" Watch "SQL server : How to group by the data by monday to sunday as a week ?" New topic
Author

SQL server : How to group by the data by monday to sunday as a week ?

ravi sahil
Greenhorn

Joined: May 07, 2013
Posts: 4
SQL server : How to group by the data by monday to sunday as a week ?

lets take one example :

take month march 2013, if i use the week function then it will group by week 1 (3 days data) week 2 (5 days data) week 3 (5 days data) week 4 (5 days data)

and i need the week always should be start from Monday to Sunday not from any day of week.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38765
    
  23
Welcome to the Ranch
You appear to have posted in an inappropriate location, but never fear, I shall try moving the question where it is more likely to be answered.
ravi sahil
Greenhorn

Joined: May 07, 2013
Posts: 4
ravi sahil wrote:SQL server : How to group by the data by monday to sunday as a week ?

lets take one example :

take month march 2013, if i use the week function then it will group by week 1 (3 days data) week 2 (5 days data) week 3 (5 days data) week 4 (5 days data)

and i need the week always should be start from Monday to Sunday not from any day of week.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL server : How to group by the data by monday to sunday as a week ?