> if the JOB numer does not change every time yo do the select you can
> calculate it once into a variable
You lost me here.
> also can you change the DOS application in any way?
Nope.
> Arnon
>
> >>> >> SELECT job, (sum(IIF(done='yes',1,0))/count(job))*100 AS progress
> >FROM
> >>> >> mytable GROUP BY job
> >>If you have a better solution, please don't keep it secret ... :-)
> >
> >Sorry, no. I was just curious if it's fast enough. :(
> >
> >Vlad
> >
> >
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only