Devam Ediyor

T-SQL stored procedures for existing database

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

Beceriler: SQL

Daha fazlasını gör: sorted data set, conditional design, t-sql with, t-sql in, t-sql;, stored, stored procedures, Procedures, design 2 comparison tables, sql final, design simple sql, sql different, stored procedure list, compare table data, create database stored procedures, install sql part install, sql complex procedures, stored procedure create sql, SQL stored, database procedure, complex stored procedure, rollup, conditional database, string compare, design rollup

İşveren Hakkında:
( 134 değerlendirme ) Solon, United States

Proje NO: #4442843



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] Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 99%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)

Bu iş için 26 freelancer ortalamada $179 teklif veriyor


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 procedure Daha Fazla

in %bids___i_period_sub_35% gün içinde275%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(38 Değerlendirme)

Hie.. I can create store procedures for you. Deliverables will include install and uninstall scripts of 20(approx) store procedures.

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(45 Değerlendirme)

Please check private message for details.

in %bids___i_period_sub_35% gün içinde132%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

I have interest for this project.

in %bids___i_period_sub_35% gün içinde165%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

have more then 8 years of experience on ms sql server and oracle. you can choose me without any hesitation.

in %bids___i_period_sub_35% gün içinde275%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

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, M Daha Fazla

in %bids___i_period_sub_35% gün içinde262%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde143%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Over 16 years professional experience working for large UK companies

in %bids___i_period_sub_35% gün içinde242%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hi. Check your PM please.

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

I am ready to complete

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

We can do this with great quality and withing time. Please see the message

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

currently I am working as a DBA in MNC. I can complete your task within time limit.

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde205%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am very familiar with t-sql, pl/sql. I can do this job.

in %bids___i_period_sub_35% gün içinde121%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde247%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I have good background in manipulating data in SQL, so I am sure I can solve your problem. I am ready to start.

in %bids___i_period_sub_35% gün içinde132%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I would like to work on this assignment.

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

i can do this project..

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)