Path: utzoo!attcan!uunet!husc6!bloom-beacon!mit-eddie!ll-xn!ames!zodiac!jshelton
From: jshelton@zodiac.ads.com (John L. Shelton)
Newsgroups: comp.databases
Subject: How can I change representation using views?
Message-ID: <3908@zodiac.UUCP>
Date: 16 May 88 18:49:03 GMT
Sender: news@zodiac.UUCP
Reply-To: jshelton@ads.com (John L. Shelton)
Distribution: na
Organization: Advanced Decision Systems, Mt. View, CA (415) 960-7300
Lines: 31


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=