Search options (Page 221 of 400)

select
SUM(
(
     SELECT SUM(rent.rent / (datediff(rent.`end`, rent.`begin`)+1)) FROM rent WHERE `selected_date` >= rent.`begin` AND `selected_date` <= rent.`end`
     AND (CASE WHEN {ComboBox1}=-1 THEN 1=1 ELSE rent.id_car={ComboBox1} END)
)
)

from

(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v

where selected_date between {edbegdate} and {edenddate}

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
var
    discount: integer;
begin
    discount := 0;

    if (Form1.Edit1.Value >= 100) and (Form1.Edit1.Value < 200) then discount := 15
    else if (Form1.Edit1.Value >= 200) and (Form1.Edit1.Value < 300) then discount := 20
    else if (Form1.Edit1.Value >= 300) and (Form1.Edit1.Value < 400) then discount := 25;

    Form1.Edit2.Value := Form1.Edit1.Value - (Form1.Edit1.Value * discount/100);
end;

(
CASE WHEN (SELECT COUNT(files.id) FROM files WHERE files.id_Objects=Objects.id)>0 THEN 'Да' ELSE 'Нет' END
)

(
CASE WHEN (SELECT COUNT(files.id) FROM files WHERE files.id_Objects=Objects.id)>0 THEN 1 ELSE 0 END
)