how do I combine 24 rows(3 columns) into one row (

From: jennfier <jenny_at_aol.com>
Date: 18 Feb 1999 15:51:10 -0600
Message-ID: <7X%y2.51694$O54.62998@newscene.newscene.com>

i have a table that has 24 rows

name            date            hour
joe             2/1/99            1
joe             2/1/99            21
joe             2/1/99            32
joe             2/1/99            34
..
joe             2/1/99          14

i want then to go into a row like this

name    date        hour1   hour2   hour3   hour4 ...  hour24
joe       2/1/99          1        21        32       34           14

can somebody give the sql please! Received on Thu Feb 18 1999 - 15:51:10 CST

This message: [ Message body ]
Next message: TurkBear: "Re: Enterprise Manager Service Discovery Not Finding?"
Previous message: rbillingsley_at_email.com: "Enterprise Manager Service Discovery Not Finding?"
Next in thread: Roy Brokvam: "Re: how do I combine 24 rows(3 columns) into one row ("
Reply: Roy Brokvam: "Re: how do I combine 24 rows(3 columns) into one row ("
Reply: Yuri McPhedran: "Re: how do I combine 24 rows(3 columns) into one row ("
Reply: Nuno Souto: "Re: how do I combine 24 rows(3 columns) into one row ("
Reply: MStout2468: "Re: how do I combine 24 rows(3 columns) into one row ("

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US