##SQL Server ###Database, Table and Function Step 1: Run the CreateDB-Script.sql to create the database in SQL Server
Step 2: After succeeding with Step 1, run CreateScript-ResourceAllocationTable.sql to create the base table required for the application. Table can be populated using a CSV file.
Step 3: Run CreateFunction-ExplodeDates.sql to create a function that generates dates for a specified period
Step 4: Once the afore-mentioned steps succesfully complete, run the Resource Forecast (Daily view).sql script to generate report data