update personnel_data
set salary = (select sum(mlnrcd) from rpgcount where srcuser = 'Mark') * .15
where employee = 'Mark'

Just a guess? ;)

Of course, you'd have to have a way to tag each line with who created it somehow... If it was my query, I'd just assume they all belong to me--at least for the purpose of this calculation.

On 11/9/2011 9:46 AM, wdsci-l-request@xxxxxxxxxxxx wrote:
date: Wed, 9 Nov 2011 08:46:33 -0600
from: Kurt Anderson<kurt.anderson@xxxxxxxxxxxxxx>
subject: Re: [WDSCI-L] Source code

Ok, I have to ask - why does your manager want this?

-Kurt

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].