Find Jobs
Hire Freelancers

T-SQL stored procedures for existing database

$30-250 USD

In Progress
Posted about 11 years ago

$30-250 USD

Paid on delivery
I need a set of ~20 stored procedures. The SQL 2008 database has ~30 tables, related to Person Profile data. Tables have one-to-one and one-to-many relationships. Stored procedures will do different types of comparison between 2 profiles. Each rule will have 2 stored procedures, one literal, another numeric Each comparison will take 2 profile IDs and optionally other parameters. The comparisons can use referential data across multiple tables Comparison might be Boolean, numeric, or equality, type of CONTAINS with string values, or be a complex with conditional logic Example of a simple comparison, each Person has a set of Skills (one-to-many). The Skill comparison rule will: Compare skillset of both person and: 1. return numeric value proportional to the number of shared skills 2. return literal verbiage describing the output, such as “Person A and Person B both are skilled in Skill A and Skill B”. This part requires excellent English There is a table with a list of Rules, each with ID, description, variables, and weight. Weight is used to calculate numeric value in the stored procedure. A final stored procedure will do rollup across all rules and provide result in sorted by numeric output order. The exact design will be discussed and tailored with the winner. The deliverable is a INSTALL and UNINSTALL scripts, to create stored procedures
Project ID: 4442843

About the project

26 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Read and understood We have gone through your project description and we are really very interested about the job and want to start the job as soon as [login to view URL] are sending you some links of our previous SQL [login to view URL] check them for more details and the links of our our previous SQL Jobs
$99 USD in 3 days
0.0 (0 reviews)
0.0
0.0
26 freelancers are bidding on average $179 USD for this job
User Avatar
Hi, I have 8 years experience in SQL Sever development. I will provide SP's with proper coding convention, proper joins and optimized. ------------- With proper normalization, indexes and joins on tables procedures will be optimized. With execution plan we can analyze missing indexes and scans and can improve stored procedures.
$275 USD in 15 days
4.7 (38 reviews)
6.0
6.0
User Avatar
Hie.. I can create store procedures for you. Deliverables will include install and uninstall scripts of 20(approx) store procedures.
$110 USD in 3 days
4.3 (45 reviews)
6.6
6.6
User Avatar
Please check private message for details.
$132 USD in 3 days
5.0 (8 reviews)
4.2
4.2
User Avatar
have more then 8 years of experience on ms sql server and oracle. you can choose me without any hesitation.
$275 USD in 3 days
4.2 (12 reviews)
4.4
4.4
User Avatar
I have interest for this project.
$165 USD in 5 days
5.0 (1 review)
3.8
3.8
User Avatar
Hi sir, I can do it! But please send me full scope of project, describing each stored procedure. Thanks. I'm an experienced Web Developer having worked for 5+ years with PHP, Java, Solr/Lucene, Sphinx Search, Smarty, MySQL, SQL Server, ASP, JavaScript, Ajax, JQuery and CSS.
$262 USD in 3 days
5.0 (6 reviews)
3.3
3.3
User Avatar
I would like to do this. I have done similar work in the past, You may check my reviews and projects. My daily job for last 5 years is to analyze set of data (around 25 Million records) and generate Reports based on PL/SQL procedures. These reports involve SQL Pivots, CTE, Correlated Queries, Sub Queries, Aggregation, Ranking, Grouping(Rolling up). I can provide you the create/drop procedures scripts as well as sample result set. All the best for your project. Please consider me for this project. Let me know if you need any sample work from me.
$143 USD in 3 days
5.0 (3 reviews)
2.6
2.6
User Avatar
Over 16 years professional experience working for large UK companies
$242 USD in 3 days
5.0 (1 review)
2.6
2.6
User Avatar
How are you going to be calling these stored Procedures? Are you going to be running them in Query Analyzer or are they called from a browser program? For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create for 6 months. Please feel free to ask any questions I am always willing to share my experience. Best of luck with your search. Michael p.s. I am based in Phoenix AZ, PST, in case you would like to call and discuss.
$220 USD in 3 days
4.8 (3 reviews)
2.2
2.2
User Avatar
Hi. Check your PM please.
$154 USD in 2 days
5.0 (2 reviews)
1.3
1.3
User Avatar
I am ready to complete
$147 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've developed hundreds of SQL stored procedures in SQL Server 2008 for an archiving/search software for the Portuguese National Archives that is now being used in dozens of Archives. Please see my private message.
$247 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am here, ready to accomplish the task. I think that I am the right person for this, regarding my work experience as a database developer.
$154 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I am 5+ years experienced programmer.i have also worked alot on tsql for writing sql procedure. I can do the job in short span and low cost. Kindly grant me the opportunity to work with you. Regards
$113 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have excellent hands on database programming, strong Proven Technical knowledge. Currently working in a reputed MNC as Software Engineer. Have developed lots of Complex Stored Procedures. Always Delivered quality code which is manageable as well as Optimized.
$220 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested in your project.
$110 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i can do this project..
$77 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to work on this assignment.
$220 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good background in manipulating data in SQL, so I am sure I can solve your problem. I am ready to start.
$132 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have more 7 years of Software development experience On VB, VC++ and SQL. You'll have the best of possible solution is guaranteed. For any details/queries you're always welcome.
$205 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Solon, United States
4.9
134
Payment method verified
Member since Mar 5, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.