jshelton@zodiac.ads.com (John L. Shelton) (05/17/88)
I am trying to get an application going in an RDBMS (Sybase), and am having trouble building a view to present an alternative data representation. Can anyone suggest a good way to do the following: I have a base table organized as: ID Month Value ---- ------ ----- 101 jan 1 101 feb 2 101 mar 4 102 jan 3 103 jun 7 ... I'd like to create a view in more "human readable" format: id jan feb mar .... ---- ---- ---- ---- 101 1 2 4 102 3 NULL NULL 103 NULL NULL NULL ... ... Ideally, I'd like to allow updating through the view, since the view more closely corresponds with human thinking. Can anyone suggest a possible solution? Thanks in advance. =John Shelton=