>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.
Not sure about SQL, but I would do it with:
CREATE CURSOR blah_yak (year N(4), details C(10))
SELECT mytable
SCAN
FOR n = beg-year TO end-year
INSERT INTO blah_yak (blah_yak.year, blah_yak.details) VALUES (n, mytable.details )
ENDFOR
ENDSCAN
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison