(SELECT TOP 10 * FROM (SELECT TOP 5 * FROM tbl_vodaphone ORDER BY 'feedId' DESC) AS tbl_vodaphone_alias_a ORDER BY 'feedId' ASC)
I believe (but may be wrong) that this should return every record in tbl_vodaphone in reverse order, using id (an auto increment primary key) for the ordering... so the records should be returned in reverse order.
Not an MS rant or anything but my god I wish this project used a MySQL database :-(
SELECT * FROM tbl_vodaphone ORDER BY 'id' DESC
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2