Group by weekends

Does anyone know how to group by wends?Hi
http://www.aspfaq.com/show.asp?id=2519
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:0C20F505-C76B-4C39-9ECF-30B0CB10AF48@.microsoft.com...
> Does anyone know how to group by wends?

Group by weekends

Hi,
Does anyone know how to group by weekends?
Sample data and expected results, please?
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?
|||Confused,
Do you want to summarise data whcih are falling on week ends ?
|||This is the data:
value year month day
34 2006 2 1
35 2006 2 2
50 2006 2 3
57 2006 2 4
63 2006 2 5
46 2006 2 6
44 2006 2 7
35 2006 2 8
48 2006 2 9
39 2006 2 10
52 2006 2 11
58 2006 2 12
41 2006 2 13
43 2006 2 14
44 2006 2 15
37 2006 2 16
38 2006 2 17
57 2006 2 18
52 2006 2 19
54 2006 2 20
45 2006 2 21
36 2006 2 22
41 2006 2 23
56 2006 2 24
49 2006 2 25
57 2006 2 26
45 2006 2 27
39 2006 2 28
I want the average of the value column but just per each weekend.
"dineshasanka@.gmail.com" wrote:

> Confused,
> Do you want to summarise data whcih are falling on week ends ?
>
|||Hi FJC,
Use a calendar table then you will be able to query the joined tables for
weekends only.
Cheers
David Birkedale
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?
|||is this homework?
hint. datediff(), mod()
|||What do you mean?
This answer says nothing.
"Doug" wrote:

> is this homework?
> hint. datediff(), mod()
>
|||Thanks David, it worked!
"David Birkedale" wrote:

> Hi FJC,
>
> Use a calendar table then you will be able to query the joined tables for
> weekends only.
> Cheers
> David Birkedale
>
> "FJC" <FJC@.discussions.microsoft.com> wrote in message
> news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
>
>

Group by weekends

Hi,
Does anyone know how to group by weekends?Sample data and expected results, please?
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?|||Confused,
Do you want to summarise data whcih are falling on week ends ?|||This is the data:
value year month day
34 2006 2 1
35 2006 2 2
50 2006 2 3
57 2006 2 4
63 2006 2 5
46 2006 2 6
44 2006 2 7
35 2006 2 8
48 2006 2 9
39 2006 2 10
52 2006 2 11
58 2006 2 12
41 2006 2 13
43 2006 2 14
44 2006 2 15
37 2006 2 16
38 2006 2 17
57 2006 2 18
52 2006 2 19
54 2006 2 20
45 2006 2 21
36 2006 2 22
41 2006 2 23
56 2006 2 24
49 2006 2 25
57 2006 2 26
45 2006 2 27
39 2006 2 28
I want the average of the value column but just per each weekend.
"dineshasanka@.gmail.com" wrote:

> Confused,
> Do you want to summarise data whcih are falling on week ends ?
>|||Hi FJC,
Use a calendar table then you will be able to query the joined tables for
weekends only.
Cheers
David Birkedale
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?|||is this homework?
hint. datediff(), mod()|||What do you mean?
This answer says nothing.
"Doug" wrote:

> is this homework?
> hint. datediff(), mod()
>|||Thanks David, it worked!
"David Birkedale" wrote:

> Hi FJC,
>
> Use a calendar table then you will be able to query the joined tables for
> weekends only.
> Cheers
> David Birkedale
>
> "FJC" <FJC@.discussions.microsoft.com> wrote in message
> news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
>
>

Group by weekends

Hi,
Does anyone know how to group by weekends?Sample data and expected results, please?
--
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?|||Confused,
Do you want to summarise data whcih are falling on week ends ?|||This is the data:
value year month day
34 2006 2 1
35 2006 2 2
50 2006 2 3
57 2006 2 4
63 2006 2 5
46 2006 2 6
44 2006 2 7
35 2006 2 8
48 2006 2 9
39 2006 2 10
52 2006 2 11
58 2006 2 12
41 2006 2 13
43 2006 2 14
44 2006 2 15
37 2006 2 16
38 2006 2 17
57 2006 2 18
52 2006 2 19
54 2006 2 20
45 2006 2 21
36 2006 2 22
41 2006 2 23
56 2006 2 24
49 2006 2 25
57 2006 2 26
45 2006 2 27
39 2006 2 28
I want the average of the value column but just per each weekend.
"dineshasanka@.gmail.com" wrote:
> Confused,
> Do you want to summarise data whcih are falling on week ends ?
>|||Hi FJC,
Use a calendar table then you will be able to query the joined tables for
weekends only.
Cheers
David Birkedale
"FJC" <FJC@.discussions.microsoft.com> wrote in message
news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> Hi,
> Does anyone know how to group by weekends?|||is this homework?
hint. datediff(), mod()|||What do you mean?
This answer says nothing.
"Doug" wrote:
> is this homework?
> hint. datediff(), mod()
>|||Thanks David, it worked!
"David Birkedale" wrote:
> Hi FJC,
>
> Use a calendar table then you will be able to query the joined tables for
> weekends only.
> Cheers
> David Birkedale
>
> "FJC" <FJC@.discussions.microsoft.com> wrote in message
> news:936003D9-CC30-4880-AA51-48463A2C6036@.microsoft.com...
> > Hi,
> > Does anyone know how to group by weekends?
>
>