Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ryss Unger
  Where is Ryss Unger?
 Cape Town
 South Africa
 Ryss Unger
 To: Tony Berkman
  Where is Tony Berkman?
 New York
 New York - United States
 Tony Berkman
Subject: RE: SQL question or Perhaps a Table Design Question...
Thread ID: 379 Message ID: 384 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, May 25, 2001 5:09:11 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
Hi Tony,
Interseting question.

Understand that each funds can have a defferent mix of classes but are the performances for each class the same in all funds?

Ie will class 1. be the same for all funds or is the mix with class1 unique to the fund?


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