Ditutup

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.

Kemahiran: Pengaturcaraan Pangkalan Data, SQL

Lihat lebih lanjut: 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

Tentang Majikan:
( 2 ulasan ) Albuquerque, United States

ID Projek: #13468230

55 pekerja bebas membida secara purata $153 untuk pekerjaan ini

hits

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 Lagi

$157 USD dalam 3 hari
(62 Ulasan)
6.8
sumon355

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 dalam 3 hari
(109 Ulasan)
6.2
rinsadsl

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 dalam 3 hari
(41 Ulasan)
5.9
codetod

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 Lagi

$100 USD dalam 3 hari
(41 Ulasan)
5.7
fanninson45

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 Lagi

$133 USD dalam 3 hari
(13 Ulasan)
5.4
jagdishbhatt38

I am having more than 8 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 Lagi

$178 USD dalam 2 hari
(20 Ulasan)
4.5
stantum

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 Lagi

$170 USD dalam 2 hari
(2 Ulasan)
4.3
kashivw

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 Lagi

$222 USD dalam 3 hari
(3 Ulasan)
3.3
EzzoMCT

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

$100 USD dalam 3 hari
(5 Ulasan)
2.9
noxthron

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 Lagi

$200 USD dalam 2 hari
(4 Ulasan)
3.0
$250 USD dalam 5 hari
(2 Ulasan)
3.0
$155 USD dalam 3 hari
(5 Ulasan)
3.3
IMExpertEngineer

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 dalam 3 hari
(5 Ulasan)
2.1
prabakarm23

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 Lagi

$277 USD dalam 5 hari
(1 Ulasan)
2.1
angnut

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

$133 USD dalam 3 hari
(2 Ulasan)
1.4
nasisp

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 Lagi

$277 USD dalam 3 hari
(0 Ulasan)
0.0
hawkscodeaus

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 Lagi

$200 USD dalam 3 hari
(0 Ulasan)
0.0
alexandersuyarov

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 Lagi

$50 USD dalam sehari
(0 Ulasan)
0.0
nandannitk

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 dalam 3 hari
(0 Ulasan)
0.0
dkrdinesh

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 dalam 3 hari
(0 Ulasan)
0.0