--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov" <SD@...>
wrote:

> I would use many joins to calculate all variants of price at once
> and then CASE to choose needed... Or one SP.

Hi Dimitry,

Thanks for your reply, but can you please write an SQL how to solve
this, I'm very poor with CASE into SQL statement?

Thanks again