In a table i have a list of names and address's, each of these has a unique client ID, and each of these clients is allocated a caseload advisor.
In order to do a caseload audit, i have been asked to create a report with 6 random client no for each of the advisors.
I can't seem to get the random ness, i always end up with the first 10, does anyone have an idea how to do this in Sybase?
--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.
In order to do a caseload audit, i have been asked to create a report with 6 random client no for each of the advisors.
I can't seem to get the random ness, i always end up with the first 10, does anyone have an idea how to do this in Sybase?
--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.