sp_room_utilization_by_square_footage

This stored procedure generates a set of data that can be used for a standard room utililization report.

Input parameters:

        IN startDate DATETIME,
        IN endDate DATETIME,
        IN includeProspect BOOL,
        IN includeTentative BOOL,
        IN includeDefinite BOOL,
        IN includeMoveInMoveOut BOOL,
        IN includeDark BOOL,
        IN venueIds VARCHAR(16383), — optional
        IN roomIds VARCHAR(16383) — optional

Output fields:

        date,
        room_id,
        room_name,
        venue_id,
        venue_name,
        square_footage_in_use,
        total_square_footage