>Only one ORDER BY is allowed per UNION. You can use derived tables to get around it
>

>SELECT * FROM (select TOP 50 * from MyTable where PK_VAL > nVar Order by PK_VAL) dt1 ;
>UNION ALL ;
>SELECT * FROM (select TOP 50 * from MyTable where PK_VAL < nVar Order by PK_VAL DESC) dt2
>

Yes, I was thinking exactly this too.