Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Dennis...
It looks like you are filling in records. SQL is about fetching existing data. What you are looking for are cursor-based operations that fabricate/derive the data based on existing data. In this case, it is not so much fabricating data as it is creating records that do not exist.
Nick's suggestion is the way to go, regardless of whether it is VFP data or SQL data. FWIW, you can do the same sorts of cursor operations in T-SQL on SQL-Server...
>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement