>>>Hello all,
>>>
>>>I have a cursor generated by a bunch of SQL subqueries. The data in that cursor is primary keys.
>>>
>>>I want to be able to select three records in another cursor for each primary keys that are a part of that cursor.
>>>
>>>So Cursor with primary keys looks like this
>>>
>>>12354
>>>3456
>>>23
>>>
>>>Result that I would like to have
>>>
>>>12354 Whatever1
>>>12354 Whatever2
>>>12354 Whatever3
>>>3456 Something1
>>>3456 Something2
>>>3456 Something3
>>>23 Other1
>>>23 Other2
>>>23 Other3
>>>
>>>Can this be done with a SQL construct?
>>
>>Hi Denis,
>>
>>the cheapest way without brain squeezing:
>>
>>create cursor curhelp (i1 I)
>>append blank
>>append blank
>>append blank
>>
>>select;
>> cur1.*,;
>> Cur2.i1;
>> from yourcursor as Cur1;
>> inner join curhelp as Cur2;
>> on .t.;
>> into cursor curTarget
>>
>>use in curhelp
>>
>
>It really looks like brain squeezing will be needed in this case :-)
>
>Thanks for the suggestion. Interesting solution but let me tell you more. In fact I should've given you more information to begin with. My bad.
>
>So like I said original cursor cursor contains primary keys.
>
>From that cursor I need to search for dates that are in another cursor. I need to get the most recent dates. Let's say 3 most recent dates.
>
>Cursor EmployeeId
>Contains primary keys for the employees that need to be searched.
>One field only : Primary key
>
>Cursor WasHere
>Contains all the dates the employees were here.
>Field could be : EmployeeId and DateEmployeeWasHere (format for date is YMD)
>
>
>Content of cursor EmployeeId
>124
>52
>
>Content of cursor WasHere
>
>124 2015/01/01
>124 2014/01/01
>124 2013/01/01
>124 2016/01/01
>52 2015/02/02
>52 2014/02/02
>52 2013/02/02
>52 2016/02/02
>
>The result that I want is :
>
>124 2016/01/01
>124 2015/01/01
>124 2014/01/01
>52 2016/02/02
>52 2015/02/02
>52 2014/02/02
This is tricky in VFP (easier in SQL Server), but there are a couple of options. This article shows two ways to do it in VFP and then switches to SQL Server:
http://www.tomorrowssolutionsllc.com/Articles/Getting%20the%20Top%20N%20for%20each%20Group.pdfTamar
