• I haven't tried, but are you sure you can convert a uniqueidentifier to a bigint?

    As to ordering by a uniqueidentifier, it sorts in ascending or descending order as if it is converted to a CHAR(36) value, or at least that is my experience with them.