Query Help
From: Joe Horton (horj235)
Date: 06/09/04
- Next message: Anith Sen: "Re: how do i create a view within a procedure that uses a variable defined in the procedure"
- Previous message: lindawie: "Re: how do i create a view within a procedure that uses a variable defined in the procedure"
- Next in thread: Anith Sen: "Re: Query Help"
- Reply: Anith Sen: "Re: Query Help"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 08:57:54 -0700
Having a brain fart and I know this is simple but I've already wasted a
couple hours - so I was wondering if someone could help.
Example Source Table:
Id: Company: StatesCovered:
1 ABC WA
2 Car Toys IL
3 Car Toys WA
4 Car Toys FL
5 Car Toys NY
6 Frys CA
7 Frys WA
8 Frys KY
9 Bobs NY
10 Bobs KY
Result Set Desired:
Company: StatesCovered:
ABC WA
Car Toys IL, WA, FL, NY
Frys CA, WA, KY
Bobs NY, KY
- Next message: Anith Sen: "Re: how do i create a view within a procedure that uses a variable defined in the procedure"
- Previous message: lindawie: "Re: how do i create a view within a procedure that uses a variable defined in the procedure"
- Next in thread: Anith Sen: "Re: Query Help"
- Reply: Anith Sen: "Re: Query Help"
- Messages sorted by: [ date ] [ thread ]
