T-SQL stored procedures for existing database

IN PROGRESS
Bids
27
Avg Bid (USD)
$175
Project Budget (USD)
$30 - $250

Project Description:
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

Additional Project Description:
04/23/2013 at 22:07 ICT
The work will require some SQL design and your optional suggestions to improve the structure for better SP performance.

For the literal SPs, please indicate your proficiency in English grammar

Skills required:
SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire sadeque
$ 275
in 3 days
Hire feninsoftech
$ 275
in 15 days
$ 132
in 3 days
Hire amcsummers
$ 220
in 3 days
$ 242
in 3 days
Hire IntellectMatters
$ 143
in 3 days
$ 110
in 3 days
Hire luki555
$ 154
in 2 days
Hire dstuyen
$ 121
in 3 days
$ 154
in 4 days