aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_db_import_roomrecap
Parameters
Name
Type
Mode
row_count
integer
INOUT
Definition
BEGIN DELETE FROM recapitulate; INSERT INTO recapitulate (date_ref, total_rooms, ooo_rooms, oos_rooms, ooi_rooms, occ_rooms, occ_adult, hsu_rooms, hsu_adult, comp_rooms, comp_adult, individual_rooms, individual_adult, individual_revenue, group_rooms, group_adult, group_revenue, arrival_rooms, arrival_adult, departure_rooms, departure_adult, day_used_qty, booking_rooms, booking_adult, walk_in_rooms, walk_in_adult, early_checkout, extended_stay, canceled_rooms, canceled_adult, no_show_rooms, no_show_adult, tomorrow_expected_arrival, tomorrow_expected_departure) SELECT dateref, ttlrm, ooorm, oosrm, ooirm, occrm, occpax, hsurm, hsupax, comrm, compax, indqty, indpax, indrev, grpqty, grppax, grprev, arrqty, arrpax, depqty, deppax, dayuse, bkkqty, bkkpax, wlkqty, wlkpax, ecoqty, xciqty, clxqty, clxpax, nosqty, nospax, exparr, expdep FROM x_recap; --WHERE dateref < '2019-05-28'; END