RE: SQL grouping

Lim,

You just want to convert the data in the DB to the same format as what is in 
the spreadsheet so you can manually compare?

If so, simply import the data into a spreadsheet from the DB and use the 
functionality of the spreadsheet to do it.  In Excel you'd want to create a 
"Pivot Table".

I've also done something similar in Access using crosstab(?) queries.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx]On Behalf Of
> Lim Hock-Chai
> Sent: Thursday, January 13, 2005 12:39 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL grouping
> 
> 
> This is an one time fix.  There are only 2 to 3 features to 
> deal with for a given phone#.  I recevie the data in a 
> spreadsheet.  However, our database is in the later format.  
> Another word, pleeease give me the example.
> 
> 
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Tony Carolla
> Sent: Thursday, January 13, 2005 11:27 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: SQL grouping
> 
> 
> If there are a fixed, reasonable number of feature codes, and a fixed,
> reasonable number of codes for any given ph#/extension, then you could
> do it with UNIONS and CASE statements.  But this is probably not the
> case <---- pardon the pun.
> 
> If it is the case, let me know, and I could give you an example.
> 
> 
> On Thu, 13 Jan 2005 09:28:48 -0600, Lim Hock-Chai
> <Lim.Hock-Chai@xxxxxxxxxxxxxxx> wrote:
> > David, let me know if this should not post here.
> > 
> > I have a file that contains data looks something like this:
> > 
> > Phone#         Phone Ext#    Feature
> > 1234567980      1234567       ABC
> > 1234567980      1234567       DEF
> > 1234567980      1234567       XXX
> > 1234569999      9994567       GXX
> > 1234569999      9994565       XXA
> > 6019991234                    ABC
> > 
> > Is there a easy way to transform it to look like this using 
> interavice SQL if I know that the most feauture an unquie 
> phone+ext can have is 8?
> > 
> > Phone#      PhoneExt#     Feat1    Feat2    Feat3    Feat4  
>   Feat5    Feat6    Feat7    Feat8
> > 1234567980   1234567       ABC      DEF      XXX
> > 1234569999   9994567       GXX      XXA
> > 6019991234                 ABC
> > 
> > --
> > This is the RPG programming on the AS400 / iSeries 
> (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> > 
> > 
> 
> 
> -- 
> "Enter any 11-digit prime number to continue..."
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>