Re: how can i put multiple statmwnts in sum(case...
From: Totti <saliba.toufic.george_at_gmail.com>
Date: Sun, 6 Jan 2008 07:06:08 -0800 (PST)
Message-ID: <7476c55e-33c4-4867-83e3-0e731e138a0d@d4g2000prg.googlegroups.com>
else 0 end.
and so on so forth,
than add % s under 'base' to get the final amount paid for carrying it, since the fee is a percentage of the sales. the reason i want to use case is because i thought it might do my job since i wanted to do the math of all these percentages and i thought that sum of case would be a good approach. Received on Sun Jan 06 2008 - 09:06:08 CST
Date: Sun, 6 Jan 2008 07:06:08 -0800 (PST)
Message-ID: <7476c55e-33c4-4867-83e3-0e731e138a0d@d4g2000prg.googlegroups.com>
Thank you Mr. D.A. Morgan
i am sorry, i didnt make my self clear, it was my fault , the way i
wrote the procedure; i meant to say :
i.e.
if ('base' and 'east') --> 1.5%,
if ('base' and 'west') --> 2.2%,
if ('base' and 'north')--> 0.95% .....
else 0 end.
and so on so forth,
than add % s under 'base' to get the final amount paid for carrying it, since the fee is a percentage of the sales. the reason i want to use case is because i thought it might do my job since i wanted to do the math of all these percentages and i thought that sum of case would be a good approach. Received on Sun Jan 06 2008 - 09:06:08 CST