I want to use Python to modify data in mssql.

$30-250 USD

Opravljeno

Objavljeno

pred približno 6 leti

$30-250 USD

Plačilo ob dostavi

I am using Python to store JSON data as mssql. Same pv_key needs to have the same pv_sdate and pv_league values, however sometimes due to the input error wrong value is entered. Therefore, I want to modify the pv_sdate and pv_laegue values to be same according to the first line of pv_key saving the JSON data as mssql. Please refer to Excel File

Microsoft SQL Server

Python

SQL

ID projekta: 16358184

Več o projektu

11 ponudb

Projekt na daljavo

Aktivno pred 6 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@zhangyingtai

Hello sir I understood what you want through job description clearly and am confident. I can start the work right now and deliver the result in a day. Best, Jiang

$111 USD v 1 dnevu

4,9

(126 ocen)

7,6

11 freelancerjev je oddalo ponudbo s povprečno vrednostjo $109 USD za to delo

@hunmin888

Hi, sir! I checked your project requirement. I have a good skill in python and mssql programming. So I hope you will give me this project. If you award this project to me, we'll complete it in time. Our budget may be negotiable Thanks

$155 USD v 3 dneh

5,0

(45 ocen)

6,3

@dustinglass

I've been successfully leveraging MSSQL and Python for data validation for over two years now at a mid-sized company. Your problem can cause major issues, but the solution is simple. Whenever a row is inserted, we will need to check for a reference to the instance of pv_key with the minimum pv_id. For US$50 I can clean up your existing records and also add a function to your Python script to prevent the error from being reintroduced. I just ask for two full days of project time to make sure I deliver top quality to you.

$50 USD v 2 dneh

4,7

(4 ocen)

3,2

@webspicevw

These fields you highlighted in excel file, are they fields in the JSON content that is stored in MSSQL or the column fields in MSSQL? I am going to make an assumption that they are columns. Either way, I can do this. If there is no reference table for pv_key, pv_sdate and pv_league- I can take the most used value and put it in other fields.

$30 USD v 3 dneh

4,9

(6 ocen)

2,8

@Valuesolutions

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

$210 USD v 3 dneh

2,5

(5 ocen)

4,3

@stacyhouse

Have done many such projects. Its a piece of cake for me! Will be able to complete in 3 days. Also will provide you an API for free in flask. I will not give you just some code but deploy it on your server on teamviewer so you can be happy and forget about anything else! Please chat so we can discuss!

$111 USD v 3 dneh

5,0

(1 ocena)

1,9

@BeyoutiF00L

BeYoutifool designs, are creative, unconventional, and impeccably unique. These designs give personality to your brand. The convergence of brilliance and simplicity, is the inception of your success

$30 USD v 2 dneh

5,0

(2 ocen)

1,5

@k2lsuthar

A proposal has not yet been provided

$88 USD v 3 dneh

2,6

(1 ocena)

0,8

@buzzdev

Hello, I am professional python developer on daily basis. Portfolio of my skills is quite wide, because i must solve multitude of development challenges in complex IT environments. This includes writing in python, html, css, javascript, shell scripting, server knowledge, various databases, etc. I'd be more than happy to help you fixing your data.

$111 USD v 3 dneh