Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this be done via SQL?
Message
From
17/12/1999 09:02:59
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can this be done via SQL?
Miscellaneous
Thread ID:
00305211
Message ID:
00305211
Views:
62
I want to take a table that looks like this...

Beg-year End-year Details
1975 1979 blah,blah,blah
1981 1984 yak, yak, yak

and turn it into this...

Year Details
1975 blah,blah,blah
1976 blah,blah,blah
1977 blah,blah,blah
1978 blah,blah,blah
1979 blah,blah,blah
1981 yak, yak, yak
1982 yak, yak, yak
1983 yak, yak, yak
1984 yak, yak, yak

Is this possible? Please advise.

THanks.
Next
Reply
Map
View

Click here to load this message in the networking platform