
Completed
Posted
Paid on delivery
I'm looking to hire someone who is able to design a SQL query with a procedure. The procedure must return a combination of integers given a target. I have a database of hotels each with a certain amount of available rooms. I need a procedure which returns hotels if a combination of available rooms exists. Example: Database tables: hotels, rooms Hotel 1 has 30 rooms which fit 2 people each, 5 rooms which fit 3 people each and 2 rooms which fit 5 people each Hotel 2 has 20 rooms which fit 2 people, 12 rooms which fit 3 people each and 1 room which fits 10 people Hotel 3 has 2 rooms which can fit 20 people each and 1 room which can fit 100 people I need to query the database to return hotels which has rooms which can fit (eg.) 70 people and I need to know what combination of rooms that would be. In this example the query should return 0: [hotel 1, [30 x 2 person room, 2 x 5 person room]] 1: [hotel 2, [17 x 2 person room, 12 x 3 person room]] The query should not return hotel 3 as there is no combination of rooms that accommodates exactly 70 people.
Project ID: 24335718
43 proposals
Remote project
Active 6 yrs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Verified SQL expert, certified in the top 3% of all freelancers globally. Have written many complex queries powering international multi million dollar companies. Happy to assist you with your project, and ready to start right away.
$120 USD in 2 days
3.3
3.3
43 freelancers are bidding on average $133 USD for this job

Hi there! I'm an experienced .net software developer (+10 years) I already have developed and optimized multiple SQL queries, so I'm sure that I can develop this query within the day. Best Regards
$88 USD in 1 day
6.8
6.8

Hi! This sound like an interest challenge. If you can send a sample of database. I'll code it today. without being awarded. you can award after I show you the query working Thanks! Felice
$140 USD in 2 days
7.0
7.0

Hey I am a Full stack developer and have great command with SQL queries as well have seen your requirements they seem interesting so willing to assist you with this as well
$80 USD in 2 days
6.1
6.1

Hello,there. I have been through the job description and I am very interested in this - 'SQL "Combination" Algorithm Query with Procedure'. I've already done this kind of project before. I am a senior software developer and I can have it done on time. Skills: Database Programming, Mathematics, MySQL, Software Architecture, SQL Please come in contact with me. Thanks really.
$155 USD in 1 day
5.9
5.9

Hello. I just read your posting. It sounds like you need a SQL and Algorithm Expert. I have experience in ACM ICPC so I always use the best algorithm. I can perfectly finish your project in a short time. If you give me a chance, I will do my best for you. Regards, Daniel Ramos Garcia
$100 USD in 1 day
5.4
5.4

I understand your requirements .... I am Query and Procedure Expert last 20 years ...your similar like multiple return i already work, so no issue , very much interested ....
$95 USD in 7 days
5.4
5.4

Hello I hope all's well with you. I would like you to consider me as a programmer for your project. I can code this via Ms Access app.. I’m an Access/VBA developer and mathematician with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses- please see my portfolio here. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. I charge $250 , but I can offer a lower rate. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab Esartia
$250 USD in 7 days
5.6
5.6

Hello, ⭐⭐⭐⭐⭐ i am interested in this project , can begin now waiting your answer on chat Regards ⭐⭐⭐⭐⭐
$60 USD in 1 day
4.9
4.9

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.
$222 USD in 2 days
3.5
3.5

Hi. I'm a professional programmer with 10 years of experience with SQL, mainly SQL server. The task you describe, finding the hotels with an exact match of room accomodation is not hard.
$30 USD in 1 day
3.4
3.4

Hi, there. I have read your job description carefully. I am a senior mysql, database developer and have 5+ years of experience. I am sure that I can do your job perfectly in time. Looking forward to hearing from you. Thank you
$140 USD in 1 day
3.2
3.2

I have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I am immediate available to join.
$277 USD in 1 day
3.3
3.3

Hi, I am SQL and algorithms expert. I participate in many programming contests and solve many problems like this. I also have SQL Microsoft certificate. If you award this project to me I'll help you
$200 USD in 7 days
3.4
3.4

Hi, Nice to meet you! I have much experience with Database and SQL. Through the development of enterprise applications, I made a lot of SQL statement that treat a vast business logic. For your project it is very easy for me to implement those kinds of SQL. I can deliver the best quality result within a few days. Hope your kind contact. Thanks.
$120 USD in 3 days
3.0
3.0

Hi, Thanks for the posting. I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss further. • Over 7+ Years I've been working on and around Database Design, Development & Support of MS SQL Server 2008/2014/2016. • Expertise in Writing Queries, Functions, Stored Procedures, Views Using MS SQL Server. • Hands on experience in Optimization of SQL Queries. Looking forward to hearing from you. Thanks
$40 USD in 2 days
2.7
2.7

Hello Dear, I'm expert in SQL and Databases with experience of 4 years. I have read your post correctly and I can finish it quickly and perfectly. Please contact me for more details. Regards
$140 USD in 1 day
1.3
1.3

Hi , My name is Vivek, I am an SQL expert . I have created many number of queries and stored procedures. I have done all kind of complex procedures. I read through you requirement and I am interested to work on it. I have the SQL skills to write the query and I have the mathematical ability to form such a solution too. If need I can provide any kind of sample to prove my skill. Once you provide me access to that database I will get this done at the earliest. Please initiate a chat so that we can discuss on the details of the project. Thanks Vivek
$80 USD in 7 days
1.4
1.4

Hi, I have over 10 years of experience with SQL and PLSQL coding on various platforms including MYSQL. Let me know if I can help you with this task. Thanks, Aakashi.
$30 USD in 7 days
0.5
0.5

Dear Project Manager, I have completed the code. Please ping me so that I can send you the code without being awarded and after verifying you can award. There are more possibilities for hotel 1 which my code has returned. 18*2 3*3 5*5 21*2 1*3 5*5 22*2 2*3 4*5 23*2 3*3 3*5 25*2 4*5 26*2 1*3 3*5 27*2 2*3 2*5 28*2 3*3 1*5 30*2 2*5 Regards, Banani
$30 USD in 1 day
0.3
0.3

I am an expert of MySQL. I can complete this project. If you hire me, then this project is my first task in this site. I will do my best. Thanks
$30 USD in 2 days
1.5
1.5

Warszawa, Poland
Payment method verified
Member since Mar 10, 2020
£10-50 GBP
₹12500-37500 INR
$250-750 USD
$2-8 AUD / hour
£20-250 GBP
₹12500-37500 INR
min ₹2500 INR / hour
₹400-750 INR / hour
£20-250 GBP
$15-25 USD / hour
€12-18 EUR / hour
£10-15 GBP / hour
$250-750 USD
₹600-1500 INR
₹600-1500 INR
$250-750 USD
$30-250 USD
£10-15 GBP / hour
£1500-3000 GBP
₹600-1500 INR