Odd pivot table type query
From: Shawn (shawngerty_at_hotmail.com)
Date: 11/22/04
- Next message: Vishal Parkar: "Re: Odd pivot table type query"
- Previous message: Nigel Rivett: "RE: pb with "QUOTED_IDENTIFIER""
- Next in thread: Vishal Parkar: "Re: Odd pivot table type query"
- Reply: Vishal Parkar: "Re: Odd pivot table type query"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Nov 2004 15:49:47 -0800
I've been unable to find a way to write the following
query.
Assuming this table:
Year Quarter
---- -------
1990 1
1990 2
1990 3
1990 4
1991 1
1991 2
1991 3
1991 4
Does anyone know how to write an SQL query to generate the
following results?
Year Quarter
---- -------
1990 1,2,3,4
1991 1,2,3,4
- Next message: Vishal Parkar: "Re: Odd pivot table type query"
- Previous message: Nigel Rivett: "RE: pb with "QUOTED_IDENTIFIER""
- Next in thread: Vishal Parkar: "Re: Odd pivot table type query"
- Reply: Vishal Parkar: "Re: Odd pivot table type query"
- Messages sorted by: [ date ] [ thread ]
