5522 The RANDOM function can not be used in more than one SELECT query clauses.
Explanation:
If Random function is called from more than one clause in the same SELECT/UPDATE query, this error is generated. Such usage is not allowed for semantic simplicity.
Generated By:
ParFdRan
For Whom:
End User.
Remedy:
Call the functions in multiple steps using derived tables or views.