SQL stored procedure to choose items based on user's preferences

I am looking for someone with expertise in SQL, who can write a stored procedure to execute the function described below. I will provide you with the necessary database and info once you are hired for the job.

Our project's goal is to find as many items as possible given a particular user’s profile and preference. Each item with its dataset has been categorized into groups in the database. The user’s profile will dictate the groups and the preferred dataset for each group. An item’s dataset will be compared to the group’s dataset to see if it will be selected. For example, items will be selected if any of these criteria occur 1) ALL of item’s dataset are equal to or are less than the group’s dataset 2) ALL of item’s dataset are more than 190-200% of the group’s dataset 3) ALL of item’s dataset are 47-50% less than the group’s dataset. The final result list should also factor in user’s preferences and should show as many items from the desired groups as possible.

In order for us to consider you for this project, please send us a precise summary of your steps and/or pseudocode of how you would perform this work to be clear of these requirements. Thank you for your interest in this project.

Only serious bidders please. I like a reliable and professional person/team since I have no time to waste.

5 + years communication and competent reading, writing, and verbal English skills.


1) I do not pay nothing in advance

2) I will release milestones after 50% of delivered work

3) please bid ONLY SURE at 100% to delivery all the system in 5 days no more

4) I could have deal for a monthly/hour based salary to maintenance after work is finished

5) no cursor or loops, and SQL should be optimized and written using a set based approach

6) being a SQL MVP is a big plus to consider

Taidot: tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: items based stored procedure, writing pseudocode, writing a procedure, team approach database, steps to writing a summary, steps to writing, software milestones, professional summary for a job, milestones software, desired salary, stored procedure based user, sql less than, professional profile example, mvp architecture, how to find a professional, stored, sql software, salary software, Pseudocode, sql final, function stored procedure, sql stored function, stored procedure function, writing professional profile, stored procedure list

Tietoa työnantajasta:
( 2 arvostelua ) SomeCity, United States

Projektin tunnus: #4243676

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, I have 8 years experience in SQL Server i writing stored procedures, performance optimization etc. This can be achieved by first joining tables and applying % on resultant data.

$200 USD 5 päivässä
(41 arvostelua)

Hi, Please check inbox.

$200 USD 5 päivässä
(9 arvostelua)

I could help you, but description is not very [login to view URL] send me more information

$250 USD 5 päivässä
(7 arvostelua)

Hi, Database expert having 8+ yrs of IT experience. Please see your PM for more details.

$50 USD 5 päivässä
(2 arvostelua)

Hi, I have good experience of working with sql queries and procedures. I can create this procedure. Please see private message.

$100 USD 3 päivässä
(6 arvostelua)

Please see PM

$225 USD 4 päivässä
(4 arvostelua)

I work with SQL and PL/SQL since 1992, including ETL and Data Warehouse and I have Oracle Certified Professional (Internet Application Developer Rel. 6/6i). I was instructor of Oracle Academy in Brasil, including those Lisää

$250 USD 5 päivässä
(2 arvostelua)

Hi, I have experienced in writing SQL procedures. I am interested on your project and I strongly believed that I can delivery work on time. I am looking forward your respond. Best Regards.

$30 USD 2 päivässä
(3 arvostelua)

Bob has extensive knowledge of SQL.

$350 USD 5 päivässä
(0 arvostelua)

Pls clear what u need,functionality.

$250 USD 3 päivässä
(0 arvostelua)

Get ready to start the work. - Thanks.

$175 USD 4 päivässä
(0 arvostelua)

regards I have over 10 years of experience with SQL, I can support this work without any problem. Any doubt I'm at your service

$120 USD 5 päivässä
(0 arvostelua)

Hello! Please see PM where i described an algorithm which i would apply. I have 4 years experience in stored procedure development (specifically - Oracle PL/SQL), so i think that i can deal with your task.

$175 USD 5 päivässä
(0 arvostelua)

Hi! I am Brainbench certified RDBMS expert, having excellence on SQL and procedural experience. Please do let me now, in case you would want to consider my bid. I am available on pm as well.

$150 USD 5 päivässä
(0 arvostelua)

have experience more than 7 years in SQL server

$170 USD 3 päivässä
(0 arvostelua)