> > Any suggestions on my DB design and query to display the values in matrix
> (pivot) format?
>
> Simple client-side code can show you the matrix in any convenient form.
> There is no point to do that on server.

I disagree!

There are times when I would love to be able to pivot data on the server, to further process the data an SP.

Also, performing the pivot on the server could reduce the total amount of data transferred to the client.


Sean