Creating table fields that link from the records

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?

Thankyou!
Thanks, but apparently that's not the case I'm expecting.
So what I expect is how to create a table that has fields coming from the records from the previous table. These fields automatically pulls out the data from appropriate records in the previous table, not by filling it manually via query. And when a new kind of distinctive record is added in the previous table, that new kind is placed as the fields as well.
In the above example, the distinctive records from previous table are TSNode1-5.
Once again thanks for the rply. I think I must change the thread's title so ppl don't misundertand it.
PS: For syntax example, use [PrevTable] as previous table, and [NewTable] as the new table.

Would Inner Join solve this problem?

Sounds to me as if you'll need to create a temp table, then loop through a cursor on the source data and use ALTER TABLE on the temp table to add columns as required, and set the column values as required. You will probably need to use dynamic SQL for this.
You can then return the temp table as the result of a stored procedure.

k, I'll try that. Thanks.

Ok, so I have solved this using my own way. I don't create fields from the records. Thanks alot btw,