Jamie Collins wrote:
*** Error: ')' expected here (TOP)

I think this may be the stumbling block:

See various posts:

http://groups.google.com/groups?q=%2...prietary+celko

e.g. "SELECT TOP (n)is a non-relational, strictly (MS) proprietary
"feature"... (use) a subquery to establish a subset based on a count."


Looks like at least some version(s) of U/SQL support the "TOP n" feature,
however:

http://www.transoft.com/support/RelN...USQL310407.htm

But I would guess you're probably correct if the OP can't get 2 different
TOP n queries to work.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]