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
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
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 [url removed, login to view] are sending you some links of our previous SQL [url removed, login to view] Daha fazlası
27 freelancers are bidding on average $175 for this job
I have total more then 5 years of experience in SQL database developer. i am interested on your project. i would like to work with you. Thank you.
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.
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.