Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
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.


Comment on Re^2: X, Y Table structure
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://903970]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (7)
As of 2015-07-30 11:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (271 votes), past polls