Hi,
 
I am trying to form a matrix from a SQL query result.
 
The SQL query result looks like this:
 
equity_id         date              returns
1                 20050619          0.12
2                 20050619          0.03
1                 20050620          -0.01
2                 20050620          0.01
 
The target matrix looks like this:
 
 
date                     1               2
20050619           0.12            0.03
20050620           -0.01           0.01
 
Any suggestion would be much appreciated.
 
Many Thanks.
 
Gilbert

	[[alternative HTML version deleted]]


