Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql counting duplicates, possible
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01620702
Message ID:
01620735
Vues:
82
This message has been marked as the solution to the initial question of the thread.
You should have included minVS into the final curFinal. Anyway, it doesn't matter, I know that minVS is correct and the KeepInfo is also correct. KeepInfo marks 1 every row with minimum Vs per date group. The rest of the rows (other duplicates) will be marked 0.

So, everything is correct according to the logic we applied. If you need different results, please provide correct logic then.

>no, with curFinal open, I first used Browse. Looked at the data. Then to show you, I used a: copy to myText type csv fields mDate, Vs, mRec, Keepinfo, cntdups, curDups.MinVs. I then formated the data in Word and presented it here. keepInfo is still doing what is shown below.
>
>>>
>>>Table myTable
>>>field names------Type----number of characters
>>>mDate-------------D------8
>>>Vs----------------C------200
>>>Debit-------------N------12 with 2 decimals
>>>
>>>
>>>output from curDups
>>>
>>>
>>>minvs------mdate----------cntdups
>>>conso------05/28/2013------3
>>>henr-------08/28/2013------2
>>>key--------09/16/2013------2
>>>menu-------09/18/2013------2
>>>
>>>
>>Ok, everything is correct then according to the logic. I assume you manually typed your previous result and didn't type minVs correctly.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform