Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tony Berkman
  Where is Tony Berkman?
 New York
 New York - United States
 Tony Berkman
Subject: SQL question or Perhaps a Table Design Question...
Thread ID: 379 Message ID: 379 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, May 25, 2001 3:39:54 PM         

Hello People,
I have a table set up with the following fields: date(D),fund_id(C,10),shareclass(C,10),performance(N,10,3). For every unique fund_id there are anywhere from 1 to 25 share classes with performance history over a range of dates. I want to set up a way to update the performance values for a particular fund in a tabular format. For example, if FundA has 4 share classes and is chosen it would look like:

Date Class1 Class2 Class3 Class4
01/01/01 2.2 2.0 2.3 1.9
01/02/01 -1.5 -1.3 -1.2 -1.7
05/25/01 5.3 4.9 5.0 5.1

i.e. like a spreadsheet...

Is there a way to do this with a view created from a self-join? Should I set the table up differently. There are thousands of funds, so the file would get awfully big if I had a field for each possible share class. I am new to SQL so I apologize for my ignorance if the answer to my question is obvious or if I haven't explained my problem succinctly.

Thanks in advance!

- Tony


SQL question or Perhaps a Table Design Question... Posted by Tony Berkman @ 5/25/2001 3:39:54 PM
RE: SQL question or Perhaps a Table Design Question... Posted by Ryss Unger @ 5/25/2001 5:09:11 PM