Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^2: X, Y Table structure

by Anonymous Monk
on May 10, 2011 at 12:28 UTC ( #903970=note: print w/replies, xml ) Need Help??


in reply to Re: X, Y Table structure
in thread X, Y Table structure

FWIW, AFAIK, its temporary, for creating reports, like SQLite::VirtualTable::Pivot shows
Given this table : Student Subject Grade ------- ------- ----- Joe Reading A Joe Writing B Joe Arithmetic C Mary Reading B- Mary Writing A+ Mary Arithmetic C+ A pivot table created using the columns "Student" and "Subject" and th +e value "Grade" would yield : Student Arithmetic Reading Writing ------- ---------- ------- ---------- Joe C A B Mary C+ B- A+
Because I forgot all about VIEWS/PIVOT, I did the transformation manually.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://903970]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (2)
As of 2017-11-21 05:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (295 votes). Check out past polls.

    Notices?