In a sotred process being coded in EG, is there a way, in a query, to obtain the first occurrence of a data field? Something like the following pseudocode....
Create table suchandsuch;
In short, say I have 10 occurrences of a record (no, not duplicates) for Joe Schmoe, but I only want to gather info for the first occurrence. I know how to do this in MS Access queries, but haven't seen anything about it for stored processes.
I will try to answer as match as i understand the question:
You have a task in the data menu called "Sort the data". You wil sort the data by the name for example and the "Options" folder, in the "double record" you will indicate "Keep only the first record for each group"
You can also use, if you want to, the PROC SQL with GROUP BY option.
NB: I translate phrases from french because i have the french version of Guide. So may be the indications will not be exactly the same.