Yes, that's it!! It worked like a charm Thank you very much Rafael
El 21/02/2011 16:49, Gérard Lochon escribió: >> But I do not want to have a VFP index in this cursor or have to create >> another cursor from the obtained recordset. I just want to get the >> cursor directly from SQL Server, ordered from 13 to 22. >> >> Any suggestions? > You may use a nested subquery : > > SELECT * FROM (; > select top 20 itemcode,(some more records) ; > from silver.dbo.items ; > where itemcode< 23 ; > order by itemcode desc ; > ) AS xx ; > ORDER BY itemcode > > Hope this helps. > > Gérard. > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
