En cours

Write a Custom T-SQL Stored Procedure for SQL Server

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.

Compétences : Programmation de bases de données, SQL

Voir plus : write excel macro sql server stored procedure, write stored procedure sql, stored procedure write custom search condition, calculate data write table stored procedure sql, sql server stored procedure copy data, transaction sql server stored procedure, call stored procedure bcp sql server, sql server exec stored procedure copy table table, sql server stored procedure copy data table, stored procedure sql bcp, test procedure sql server 2000, sql server stored procedure copy table, web part parameter stored procedure sql sharepoint 2007, bcp procedure sql server 2000, sql server 2005 stored procedure latitude longitude search, script stored procedure sql server 2000, sql order custom sql, sql server stored procedure resize image, sql database custom backup script, writing procedure sql, zip code radius stored procedure sql server, sql server 2000 bcp stored procedure, sql server 2008 proximity search stored procedure, sql server 2005 stored procedure copy table, stored procedure sql copy table

Concernant l'employeur :
( 4 commentaires ) Sarasota, United States

N° du projet : #12646587

Décerné à :

hwanghendra

Hello, it's just a bunch of IF's. Nothing too complicated. What is void() ? ............................

155 $ USD en 3 jours
(110 Commentaires)
6.2

26 freelance ont fait une offre moyenne de 185 $ pour ce travail

truongnguyen86

Hello there, i'm expert on SQL Server also T-SQL, i've done many complex project from data mining to searching category in both SQL and MySQL and i'm totally confident that i can handle this for you. Actually i saw the Plus

250 $ USD en 3 jours
(120 Commentaires)
6.2
A2Design

Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here [url removed, login to view] Here’s a little video about our team too! ht Plus

250 $ USD en 2 jours
(2 Commentaires)
5.8
aanvikm

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 Plus

250 $ USD en 3 jours
(12 Commentaires)
5.2
fanninson45

INTRODUCTION I have done a similar project like this recently for a Canadian Sporting Organisation here [url removed, login to view] SHOWCASE An experienced Microsoft Certified Prof Plus

155 $ USD en 3 jours
(12 Commentaires)
5.4
papon13

Greeting! My Name is Noor All Safaet and expert in Software and Web Development. I would love to have the opportunity to discuss about your project with you. 3.5+ years of experience as Web, Software and Database D Plus

250 $ USD en 9 jours
(14 Commentaires)
4.3
166 $ USD en 3 jours
(19 Commentaires)
4.3
vinaysinghh

A proposal has not yet been provided

111 $ USD en 2 jours
(22 Commentaires)
4.3
phiona06

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 struc Plus

111 $ USD en 2 jours
(12 Commentaires)
3.8
jagdishbhatt38

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 utili Plus

250 $ USD en 6 jours
(6 Commentaires)
3.8
azmatakhtar

i want to discuss this with you. u can see my profile iam a senior developer with SQL server certificagion

222 $ USD en 3 jours
(9 Commentaires)
3.5
hatimtaj

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 Plus

80 $ USD en 3 jours
(4 Commentaires)
3.2
vw7590795vw

Please review my profile. [url removed, login to view] 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 en 10 jours
(9 Commentaires)
3.1
msalahii

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 Plus

150 $ USD en 2 jours
(4 Commentaires)
3.0
ebrahimhassan

Hi, i can complete required task fast and in high quality , i already created many procedures with dynamic SQL ,

100 $ USD en 3 jours
(1 Commentaire)
0.8
gnrupesh

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 w Plus

166 $ USD en 7 jours
(1 Commentaire)
1.0
155 $ USD en 4 jours
(0 Commentaires)
0.0
133 $ USD en 10 jours
(0 Commentaires)
0.0
liviu19

Converting multiple scripts into one stored proc sounds like the sensible thing to do. Looking forward to the actual task.

333 $ USD en 3 jours
(0 Commentaires)
0.0
ricardothomas

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 pass Plus

222 $ USD en 3 jours
(0 Commentaires)
0.0
155 $ USD en 3 jours
(0 Commentaires)
0.0