Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Contributor
3421 Points
1189 Posts
Jul 13, 2010 09:17 PM|LINK
I have a fast forward cursor whose query is ordered by a certain column in ascending order as in ==> 'PickFlag Asc'.
After fetching the first 'n' records from the above cursor, I decide to change the sort order of cursor's query to 'PickFlag Desc'.
Is such a change possible with fast forward cursor in SQL Server 2005?
sun21170
Contributor
3421 Points
1189 Posts
Changing the sort order of fast forward cursor after a few FETCHES?
Jul 13, 2010 09:17 PM|LINK
I have a fast forward cursor whose query is ordered by a certain column in ascending order as in ==> 'PickFlag Asc'.
After fetching the first 'n' records from the above cursor, I decide to change the sort order of cursor's query to 'PickFlag Desc'.
Is such a change possible with fast forward cursor in SQL Server 2005?