Microsoft TSQL/Stored Procedure

$10-30 USD

Completed

Posted

almost 3 years ago

$10-30 USD

Paid on delivery

a. Stored procedure for loading all the databases directly from a csv/text file from a folder by date timestamp. So assuming there are multiple files the stored procedure will only load the most current file by table b. Stored procedure to load incremental/delta load .. So assuming the changes are minor the job will only load that part and ensure the changes is properly tracked. So the job will load a staging table before the final table c. Stored procedure that capture all changes. d. SQL to create an aggregate table on the diagram - Derived table from all tables.

Project ID: 30380000

About the project

7 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@bizmanas

HI I have 15 years experience in Microsoft SQL Server Database Development, Postgres Development, MYSQL Database Development, C#, Python and PowerBI I would be able to help you with the project. Please ping me offline to discuss further

$100 USD in 2 days

5.0

(7 reviews)

2.7

7 freelancers are bidding on average $37 USD for this job

@freelancersandh1

As nice, communicative, friendly and open minded person, i will be glad and honored to work on your project/s. Promises: - full commitment to order - fastest execution time possible - delivery on time Database performance matters, i will help you with or write for you database queries in MySQL, MS SQL, MSAccess, SQLlite. PostgreSQL Any trouble you might have with your database, i will investigate and fix or do query optimization.

$20 USD in 7 days

5.0

(2 reviews)

2.5

@bsreddy576

Hi, I can help you with this. Pelase ping me over chat. I have more than 8 Years experience. in SQL SERVER DB Developemnt. I can create a procedure for you.

$30 USD in 7 days

5.0

(1 review)

1.6

@sreekantha86

I am Sreekanth A from India. I can do this task with .Net framework, and Entity framework core. The application will search on specified folder and search for the csv files and decode it, and save results to a MS SQL Server database.

$20 USD in 7 days

0.0

(0 reviews)

3.0

@srinivastadela

Having 5 years experience in sql server. Expert in SSMS, SSIS, SSRS and thoroughly using triggers, cursors, dynamic sub queries, jobs and indexing and expert in query optimization and managing performance issues and handling thousands of lines in single stored procedure.

$20 USD in 7 days