Suljettu

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.

READ BEFORE BIDDING:

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

About the Employer:
( 2 reviews ) SomeCity, United States

Projektin tunnus: #4243676

16 freelanceria on tarjonnut keskimäärin 178 $ tähän työhön

feninsoftech

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ä
(3 arvostelua)
3.5
ultrasonicsoft

Hi, Please check inbox.

200 $ USD 5 päivässä
(1 arvostelu)
3.4
kapoorprateek82

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ä
(7 arvostelua)
3.4
lokeshk9936

Please see PM

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

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)
2.6
oobretenov

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

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

Hi, I can help you in this project. I'm a hard-working person who can provide 100% accuracy. Thanks for considering my application.

160 $ USD 2 päivässä
(2 arvostelua)
1.9
InSolWorld

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ä
(2 arvostelua)
1.7
rbtinf

Hello. I'm experienced and certified Oracle PL/SQL (MySQL) developer.

30 $ USD 1 päivässä
(1 arvostelu)
1.0
enmesh

Pls clear what u need,functionality.

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

Get ready to start the work. - Thanks.

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

Bob has extensive knowledge of SQL.

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

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)
0.0
yuryk86

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)
0.0
freedevs

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)
0.0
bubu77

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

50 $ USD 5 päivässä
(0 arvostelua)
0.0
amresam

have experience more than 7 years in SQL server

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

As I've only been doing programming for 2 months, I ONLY bid on projects I know I can complete. Pay is definitely negotiable. Only thing that matters to me is experience and building a portfolio.

60 $ USD 5 päivässä
(0 arvostelua)
0.0