Message
From
05/04/2010 17:55:39
To
05/04/2010 17:46:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Select
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01458778
Message ID:
01458839
Views:
41
>thanks again
>Is Name + Month combination unique? yes
>And each Name repeats for each month?yes
One approach - not good performance
>Is Name + Month combination unique? yes
>And each Name repeats for each month?yes
One approach - not good performance
select T.Nam, T.ID1, (select sum(Y2010) as YTD from NewTest T1 where T1.Nam = T.Name and T1.ID1 <= T.ID1) as YTD from NewTest T into cursor crsYTDSecond approach I already wrote in my other message - use scan and intermediate cursor.