I'm running on Sybase and need a help on SQL Query. I have, say, 50 records with 10 distinct dates: April-10-2009 s/d Apr-20-2009. I want to summarize the records into a table, with each distinct node record as the name of fields. Why so that if new distinct node is added, they also update, adding the newly added node record as new fields. Technically, each distinct date contains information of 5 nodes with an node output amount. I must create a table(or view, whatever is ok) that contains fields whose name that comes from the names of 5 nodes. The records beneath the field header are the node output amount for each distinct dates. So it looks like this in the final: Date | TSNode1 | TSNode2 | TS Node3 | TSNode4 | TSNode5 | --> (These are the records from the other table, so when new records added, these fields Apr-10 9,875 8,657 5,433 6,789 5,534 also update, adding new fields here) Apr-11 8,975 10,635 9,453 8,139 6,179 Apr-12 ... ... ... ... ... Apr-13 ... ... ... ... ... Apr-14 ... ... ... ... ... ... Apr-20 Is it possible to do this?