XaBoK

За синтаксис не ручаюсь, но смысл простой — делайте Select из обобщённой таблицы с помощью дополнительного поля:

SELECT   id, name, good_name, payment
FROM     (SELECT   TOP (100) PERCENT id, name, good_name, payment, good_name AS ordr
            FROM     temp
            WHERE   (payment = 1)
            UNION
            SELECT   TOP (100) PERCENT id, name, good_name, payment, name AS ordr
            FROM     temp AS temp_1
            WHERE   (payment = 0)) AS t2_1
ORDER BY payment DESC, ordr

* This source code was highlighted with Source Code Highlighter.