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.

Taidot: Tietokantaohjelmointi, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 2 arvostelua ) Albuquerque, United States

Projektin tunnus: #13468230

55 freelanceria on tarjonnut keskimäärin 153 $ tähän työhön


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 Lisää

157 $ USD 3 päivässä
(62 arvostelua)

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 3 päivässä
(109 arvostelua)

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 3 päivässä
(41 arvostelua)

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 Lisää

100 $ USD 3 päivässä
(41 arvostelua)

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 Lisää

133 $ USD 3 päivässä
(13 arvostelua)

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 Lisää

178 $ USD 2 päivässä
(20 arvostelua)

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 Lisää

170 $ USD 2 päivässä
(2 arvostelua)

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 Lisää

222 $ USD 3 päivässä
(3 arvostelua)

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

100 $ USD 3 päivässä
(5 arvostelua)

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 Lisää

200 $ USD 2 päivässä
(4 arvostelua)
250 $ USD 5 päivässä
(2 arvostelua)
155 $ USD 3 päivässä
(5 arvostelua)

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 3 päivässä
(5 arvostelua)

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 Lisää

277 $ USD 5 päivässä
(1 arvostelu)

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

133 $ USD 3 päivässä
(2 arvostelua)

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 Lisää

277 $ USD 3 päivässä
(0 arvostelua)

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 Lisää

200 $ USD 3 päivässä
(0 arvostelua)

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 Lisää

50 $ USD 1 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)