Re: Sort User Worklist

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Wed, 4 Jun 2008 17:08:06 -0700, Random1 <Random1@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have four end users. I need to sort each worklist by alpha then divide the
count by four. This will allow each user to have equal number of accounts by
alpha based on number of active accounts for that day.

The main file which the query's are built from have a specific date of
service, and each record has a unique account number (unique identifier - no
duplicates). Ideally when they log into the database the rolling accumilitive
total for all service dates are equally split by alpha by service date. Not
sure if this is possible.... Thanks

Try four queries like:

SELECT TOP 25 PERCENT <field, field, field>
FROM Worklist
WHERE <criteria>
ORDER BY <alpha>;

SELECT TOP 33 PERCENT <field, field, field>
FROM (SELECT TOP 75 PERCENT <field, field, field>
FROM WORKLIST
ORDER BY <alpha> DESC)
ORDER BY <alpha>

etc.
--

John W. Vinson [MVP]
.

Relevant Pages