Closed

Create SQL query

We need an SQL query built for a hotel group. This query will be run at any date in time, to pull historical, future or combination of both to show what segmentation is on the books [to include revenue, room nights & average daily rate]

We will run the query and then the attached file is how we want the data to be exported from the Property Management System.

Skills: Database Administration, Microsoft SQL Server, MySQL, PHP, SQL

See more: create automated booking system, create online reservation system php sql apache, sql query create matrix report, sql commands, insert query in sql, create table oracle, sql create table primary key autoincrement, sql create table primary key, create table sql server, sql tutorial, sql create table foreign key, student registration system sql query, powershell sql query system dsn, create running total sql query, sugarcrm create sql query url, access create custom query sql, create attendance taking system sql server, write sql query display day system, create dropdown sql query moodle, sugarcrm sql query create account

About the Employer:
( 0 reviews ) Hallam, Australia

Project ID: #17906430

77 freelancers are bidding on average $997 for this job

fullymagento

Hi, We are a team of 65+ experts in PHP and Mobile apps and have more than 10+ years of working experience in all of the categories that you need assistance [login to view URL] to your job requirements, I have done many More

$1250 AUD in 20 days
(82 Reviews)
7.5
phpdeveloper100

Expert in making queries , Know MySql in detail and also make Query Builder as well , Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator More

$1086 AUD in 20 days
(75 Reviews)
7.3
xiangang

100% JOB SUCCESS!!! Hello client, I read your job posting carefully and am very interest your project. I am a full stack developer with great experience and skills in Web/iOS/Android development for over 10 years More

$1250 AUD in 20 days
(61 Reviews)
7.3
DebasisB

Hi, I am interested in the project. I have expertise in database designing and SQL serve, and I am sure I can deliver you the exact solution you are looking for. If accepted I can start immediately after bid acceptance More

$750 AUD in 5 days
(138 Reviews)
6.9
hjr122413

Hi Thanks for your posting. I have read your post and checked the attached file. As I am a talented RDBMS expert and as one who have many experiences in PMS, I am very interested in your project. I'd like to dis More

$1250 AUD in 20 days
(73 Reviews)
6.9
polarjin2017

Hello? How are you? I have good skills in sql query.. So I think we can work together. Hope to work with you. Thank you.

$777 AUD in 3 days
(74 Reviews)
6.5
luiswilliam

Hi, how are you? I'm talented web developer. I have completed lots of professional web projects successfully before. And I am continuously supporting all projects which I have done for clients..,,;',,,,,. However, More

$1250 AUD in 20 days
(63 Reviews)
6.6
codetod

Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. I ha More

$750 AUD in 5 days
(82 Reviews)
6.6
sikandermandal

Hi there, This is Sikander, I am working with SQL since 2000 , I have checked the excel sheet and it looks that we need to work Piovt Reports where we need to get Segment Total according to date and date. This will More

$1250 AUD in 20 days
(26 Reviews)
6.4
FerriSoft1

Hi, I lead a small team of Developers, but personally I have more than 10 years of experience in T-SQL, back to SQL Server 2005. Triggers, Dynamic SQL, Pivotting, SQL XML you name it. Now that you are showing an More

$833 AUD in 20 days
(14 Reviews)
6.3
wizard2015

Hi, I am experienced software developer and I can help you writing appropriate queries to extract data from your system. I will need sample database dump to work on writing queries. There likely will be multiple queri More

$1400 AUD in 15 days
(55 Reviews)
5.9
softcarve

Hi, I would like to write the query in attached format. Get in touch to discuss more. Available to start now. Regards, Manish

$750 AUD in 20 days
(110 Reviews)
6.1
cloneify

i can write the code and the query for you I have experience of fetching information and images from dynamic websites and save processed results parallelly into database/Xls/CSV etc. I have also used the cron job for More

$750 AUD in 20 days
(41 Reviews)
6.2
digidreamstech

Hello, I have checked project requirements and can work on this project. It will be delivered with quality. Thanks.

$750 AUD in 14 days
(55 Reviews)
6.0
tdteam

Hello, I'm coder, I have more than 8 years experience in html, css, jquery, php, sql, wordpress, joomla,.... I have checked excel, please discuss, thank you

$750 AUD in 20 days
(110 Reviews)
6.1
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Create SQL query . I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I More

$750 AUD in 10 days
(50 Reviews)
6.2
robnicholson

I can sort out these queries for you. To be honest based on the requirements provided it appears you have overbudgeted for effectively a few hours work. Quick Summary about me: SQL Server Certified Master (highest ce More

$750 AUD in 3 days
(25 Reviews)
5.7
AdhamSoft

11 Years working here with a rate of 5/5 This link is wordpress site we created [login to view URL] Please check this as a sample By checking that link you will know what we have I More

$750 AUD in 20 days
(49 Reviews)
5.9
vrickson

Hi, We are having vast experiences with the best team in India to work on software applications, web & mobile app , BIG DATABASE ,SQL-ORACLE-POWER BI ,ERP / SAP , CRM / BOT ( Python ), GPS Tracking etc. We have w More

$1250 AUD in 20 days
(9 Reviews)
5.9
SergioAlfaroV

Hello! I am a Computer Engineer, with a MCSA SQL Server 2014 certificate, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, data warehousing, and datab More

$900 AUD in 10 days
(14 Reviews)
5.4