>I have something to do and maybe there is somebody out there having a better solution.
>
>I have a table like that :
>
>JOB# TICKET# CLIENT# DONE
>1 1 1 yes
>1 2 1 no
>1 3 1 yes
>2 1 2 yes
>2 2 2 yes
>3 1 3 yes
>3 2 3 no
>
>I need a SQL select (or some other solution) to produce the following
>cursor :
>
>JOB# PROGRESS(%)
>1 66%
>2 100%
>3 50%
>
>So, the SQL result must have 1 record for each JOB# value and the second column is defined as :
>
>100 * (How_Many_records_with_DONE=YES / How_Many_records
>
>If you have any decent solution for that please let me know. This
>cursor have to be updated every 10 seconds and there are milions
>of records in the main table.
Actually, it'd be a little easier if you changed your done field either to a logical or a numeric using 0/1, but in this case:
SELECT job, (sum(IIF(done='yes',1,0))/count(job))*100 AS progress FROM mytable GROUP BY job
HTH
Matt
Matt McDonnell
...building a better mousetrap with moldy cheese...