Find Jobs
Hire Freelancers

T-SQL stored procedures for existing database

$30-250 USD

W trakcie realizacji
Opublikowano około 11 lat temu

$30-250 USD

Płatne przy odbiorze
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
Identyfikator projektu: 4442843

Informację o projekcie

26 ofert
Zdalny projekt
Aktywny 11 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
26 freelancerzy składają oferty o średniej wysokości $179 USD dla tej pracy
Awatar Użytkownika
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 w 15 dni
4,7 (38 opinii)
6,0
6,0
Awatar Użytkownika
Hie.. I can create store procedures for you. Deliverables will include install and uninstall scripts of 20(approx) store procedures.
$110 USD w 3 dni
4,3 (45 opinii)
6,6
6,6
Awatar Użytkownika
Please check private message for details.
$132 USD w 3 dni
5,0 (8 opinii)
4,2
4,2
Awatar Użytkownika
have more then 8 years of experience on ms sql server and oracle. you can choose me without any hesitation.
$275 USD w 3 dni
4,2 (12 opinii)
4,4
4,4
Awatar Użytkownika
I have interest for this project.
$165 USD w 5 dni
5,0 (1 opinia)
3,8
3,8
Awatar Użytkownika
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 w 3 dni
5,0 (6 opinii)
3,3
3,3
Awatar Użytkownika
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 w 3 dni
5,0 (3 opinii)
2,6
2,6
Awatar Użytkownika
Over 16 years professional experience working for large UK companies
$242 USD w 3 dni
5,0 (1 opinia)
2,6
2,6
Awatar Użytkownika
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 w 3 dni
4,8 (3 opinii)
2,2
2,2
Awatar Użytkownika
Hi. Check your PM please.
$154 USD w 2 dni
5,0 (2 opinii)
1,3
1,3
Awatar Użytkownika
I am ready to complete
$147 USD w 10 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 15 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 5 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I am interested in your project.
$110 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
i can do this project..
$77 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I would like to work on this assignment.
$220 USD w 5 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 5 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Solon, United States
4,9
134
Zweryfikowana metoda płatności
Członek od mar 5, 2002

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.