BI Report

This will contain the queries and solutions received and provided for BI report in MCI system.

SQL Query for generating the details list of reservation for a given date
Run the below query on WebCheckin database. DECLARE  @FromDate VARCHAR(12)='20210706', @ToDate VARCHAR(12)  ='20210706' CREATE TAB...
Thu, 8 Jul, 2021 at 8:36 AM