Find Jobs
Hire Freelancers

Write a Custom T-SQL Stored Procedure for SQL Server

$30-250 USD

Đã hoàn thành
Đã đăng vào khoảng 7 năm trước

$30-250 USD

Thanh toán khi bàn giao
Calling all T-SQL experts! We have a function written in basic VBScript which takes several arguments, runs some queries to build custom INSERT and UPDATE statements, which it then runs. We would like this function coded into a single stored procedure. Platform: ---------------- Windows Server 2012 SQL Server 2012 Standard Edition Description of Function: ------------------------------------------- The goal is to keep a calculated dynamic range of searches for a customer. We've been doing it successfully now for 7 years, comprising over 600,000 records. We're happy w/ the underlying database architecture and it supports our use cases very well. We're just unhappy w/ the number of roundtrips required from our front-end to the database, which is why we're ready to move this into a single stored procedure. So, if they search for a Sea Ray boat, and they've not searched Sea Ray previously (i.e. it doesn't exist in CILMAM), we would insert Sea Ray as a "make" (into CILMAM). If they search were also searching for Sea Ray w/ model years from 2012 - 2014, we would extend their Min Year and Max Year to 2012 and 2014, provided of course that the Min Year was greater than 2012 and/or the Max Year was less than 2014. As you can see, the goal of the function is to keep the CI table (customer_interest) and its associated hangoff tables (CILMAM, CILFTM, CILCM) updated to the broadest range of anything searched by the customer. The goal is to have this computed data available to any application that needs it at run-time. Please quote development of a custom T-SQL procedure to run in our SQL12 environment which accomplishes everything you see in the attached function.
Mã dự án: 12646587

Về dự án

25 đề xuất
Dự án từ xa
Hoạt động 7 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
Hello, it's just a bunch of IF's. Nothing too complicated. What is void() ? ............................
$155 USD trong 3 ngày
5,0 (113 nhận xét)
6,3
6,3
25 freelancer chào giá trung bình $182 USD cho công việc này
Avatar người dùng
Hello Sir, I am an expert VBA and SQL developer and would like to work with you on this project. Please open chat to discuss more about this stored proc. I do have SQL 2012 installed already at my local system. Thanks Aanvik
$250 USD trong 3 ngày
5,0 (37 nhận xét)
6,4
6,4
Avatar người dùng
Hello, I'm Muhammad Salah, I'm Microsoft Certified Database Administrator and i writing for you about your project after reading the requirements and I'm available and ready to start working immediately once you accept my bid, Looking forward to hear back from you. Best Regards, Muhammad Salah
$150 USD trong 2 ngày
4,9 (18 nhận xét)
4,8
4,8
Avatar người dùng
I am having more than 7 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.
$250 USD trong 6 ngày
4,9 (27 nhận xét)
4,8
4,8
Avatar người dùng
i want to discuss this with you. u can see my profile iam a senior developer with SQL server certificagion
$222 USD trong 3 ngày
5,0 (15 nhận xét)
4,4
4,4
Avatar người dùng
A proposal has not yet been provided
$111 USD trong 2 ngày
4,7 (40 nhận xét)
4,8
4,8
Avatar người dùng
Hi! I'm senior lecturer in databases with 10+ years experience in MS SQL server. I saw your function and I think I can rewrtite it to stored procedure using T-SQL and write all tests for check sp. I need database structure and some test data from your real database for testing.
$111 USD trong 2 ngày
5,0 (21 nhận xét)
4,4
4,4
Avatar người dùng
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7.1 years experience in SQL and 4.3 years experience in SSRS, SSIS. Please let me know more details and when will we start.
$240 USD trong 10 ngày
5,0 (19 nhận xét)
3,9
3,9
Avatar người dùng
Hi - one question about the void() function you're using - am I right in assuming that this is supposed to test if the field/value in question is NULL? Also, will you be able to provide a test database or something for me to test the stored procedure during development? Thanks, Hatim
$80 USD trong 3 ngày
5,0 (4 nhận xét)
3,2
3,2
Avatar người dùng
Hi, I have 15+ years experience in TSQL development in MSSQL and Sybase ASE (MSSQL was branched from this) database platforms hope to hear from you regards Babu
$140 USD trong 3 ngày
5,0 (1 nhận xét)
2,9
2,9
Avatar người dùng
Hi, i can complete required task fast and in high quality , i already created many procedures with dynamic SQL ,
$100 USD trong 3 ngày
5,0 (2 nhận xét)
2,0
2,0
Avatar người dùng
Hi, I have around 8 years of experience with data integration projects using SQL, PL/SQL, T-SQL, ETL and other tools. You'll get your optimized stored procedure that keeps the CILMAM, CILFTM & CILCM tables updated with all the customer searches. Please send me the complete table structures of all these tables including the keys, constraints and indexes. We could discuss further as I start working further on the functionality. Thanks and regards, Nrupesh
$166 USD trong 7 ngày
5,0 (1 nhận xét)
1,0
1,0
Avatar người dùng
i am hereby new...please give me one chance i will serve you best please sir allow me to work for you............
$155 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
i'm a software developer with most experience in SQL, so I can assist with your requirement, if you need more details you can contact me.
$166 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Hello! I am a Microsoft certified specialist and also I have 4 years of practical experience as DBA and DBD. I am interested in this job and I have had such experience already. Artem. Database specialist.
$200 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Converting multiple scripts into one stored proc sounds like the sensible thing to do. Looking forward to the actual task.
$333 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
$155 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Hello. I design, build and maintain computer software using C#, VB.NET, ASP.NET, MySQL and MSSQL on a day to day basis. I have over 15 years experience in the field of Software Development and I am driven by passion. Most of my work have been done for Financial, Educational and Private Sector Institutions. All of my clients are happy and satisfied with the quality work that I have produced.
$222 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I am seasoned SQL developer having experience working with fortune 500 companies in database development optimization and Report development. I would like to take this project from you on the price your easily willing to pay. I am new to freelancing so this is special concessions for my early freelancing projects. Looking forward to work with you. Thanks Waji
$244 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED STATES
Sarasota, United States
5,0
4
Phương thức thanh toán đã xác thực
Thành viên từ thg 11 9, 2013

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.