Stored Procedure for data transfer in MSSQL

I need you to develop some software for me. I would like this software to be developed for Windows using SQL. I need a Stored Procedure that will transfer data from a view and insert new records and update related existing records. This involves case statements to account for source values that don't match values used in destination table. Comparison to determine if source records should be new records and added or it they exist and need to be updated in the destination table.

There is only a single staging table named medical_restrictions_st instead of multiple tables. Also the destination table sql included in zip is not complete and will not be until tomorrow.

Skills: Database Programming, SQL

See more: i need a data entry job online where i don t have to pay to register, copy data command stored procedure ms sql, transfer data mssql mysql, mssql save data store procedure, mssql data warehouse stored procedure, sql server copy data databases stored procedure, oracle data copy stored procedure, mssql 2008 send email stored procedure, mssql copy data procedure, transfer data joomla, transfer data excel word, transfer data mobile, transfer data mysql sql server, transfer data excel multiple sheet access table, write code transfer data sql server excel

About the Employer:
( 2 reviews ) Albuquerque, United States

Project ID: #13468230

55 freelancers are bidding on average $153 for this job


I have read your requirements and am confident of delivering as required. I have a few queries/need some details: SQL version? Source and destination tables are in the same database? Comparison on how many More

$157 USD in 3 days
(62 Reviews)

Hello, As an expert in writing complex sql queries, i am very much interested to do this work. Looking forward to have a positive response from you. Thanks

$140 USD in 3 days
(109 Reviews)

Hello Good Day I can write this SP for you. I have done plenty of work with MSSQL SP. Looking forward to work with you. Thanks Rinsad

$189 USD in 3 days
(41 Reviews)

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. With More

$100 USD in 3 days
(41 Reviews)

SHOWCASE An experienced Microsoft Certified Professional with Web Programming and Administration skills across both ASP.NET MVC and PHP Development. Having the ability to take the technical lead in projects and suppor More

$133 USD in 3 days
(13 Reviews)

I am having more than 8 years of experience in IT industry.I have worked on .net(,,asp,,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili More

$178 USD in 2 days
(20 Reviews)

Hi George, I have a lot of experience with complex SQL scripts development and able to create a good stored procedure for merging your data. If you provide some samples and schema, I'll be able to quickly create a d More

$170 USD in 2 days
(2 Reviews)

I am a veteran (15+ years) developer with specific expertise in SQL Server (Sybase thru R14) and Oracle (v6 thru v12c). In this long period, I have written thousands of lines of SQL, T-SQL and PL/SQL code. I am a n More

$222 USD in 3 days
(3 Reviews)

this is initial bid till we discuss details of the scope. please message me to discuss table structure and stored procedure requirement

$100 USD in 3 days
(5 Reviews)

Hello, I'm a software engineer with anexpwriwnce of 14 years in .net and sql development. My main expertise is software systems used in hospitals (Health Information Systems). During these years I had a lot of experien More

$200 USD in 2 days
(4 Reviews)
$250 USD in 5 days
(2 Reviews)
$155 USD in 3 days
(5 Reviews)

Hello, I'm ready to write this stored for you and I believe that you just need the stored procedure and already have application that will use the procedure. Please do let me know the details

$155 USD in 3 days
(5 Reviews)

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More

$277 USD in 5 days
(1 Review)

hi, i am sql serve developer. i can work on your stored procedure.

$133 USD in 3 days
(2 Reviews)

Highly motivated SQL Server Developer with many years in IT Industry. Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2012, SSIS and SSRS. Experienced i More

$277 USD in 3 days
(0 Reviews)

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills More

$200 USD in 3 days
(0 Reviews)

Did I understand the task correctly? The procedure should check incoming data, for example, a column:ACCOM_ACTION it can only take values in ('CHNG', 'ORGA','REST','SCHD','OTHR','ANIM')? Do I need a handler, in the c More

$50 USD in 1 day
(0 Reviews)

I am currently working in exactly same technology like Oracle PL/SQL mainly creating and maintaining stored procedure for complex ERP system, I will provide the solution with quality within timeline.

$170 USD in 3 days
(0 Reviews)

I am work with microsoft technolgies for last 3 years. and i am working with various platform for web application and windows [url removed, login to view] i will complete my work for quick time and deliver the cliet time.

$30 USD in 3 days
(0 Reviews)