Batch querying work needs to be done for importing method - remote work

So, I've currently got a function that involves an xml file being imported and then reading the file, this will import a list of values. This is working as expected, however, when I would like to delete a value I'm running into two issues. The main issue currently is when it needs to delete more than 2000 paramters, giving an error as the sql server can't handle. The solution I feel would need to be then doing batch queries instead, but I'm unsure how to get it working.

Note: I can't send the application or the code base, it's not upload as well. However, I'm happy for you to remote in and work through teamviewer or anything else.

Taidot: Microsoft SQL Server, Java, MySQL

Näytä lisää: part time remote work, remote work computer programming, windows administrator remote work freelance home based, vb6 remote work, remote work sharepoint, peoplesoft remote work, programmer remote work, windows mobile remote work freelance, remote work java, system administrator remote work, Remote work, foxpro job vacation remote work, biztalk freelance remote work, delphi remote work, prevailing hourly rate remote work sqldba, remote work finnish, remote work freelance, remote work microsoft access find job

Tietoa työnantajasta:
( 6 arvostelua ) Belfast, United Kingdom

Projektin tunnus: #30182308

7 freelanceria on tarjonnut keskimäärin £173 tähän työhön

(683 arvostelua)

Hello, As an expert in ms sql server, I am very much interested to help you fixing the issue. We can use anydesk. Looking forward to have a positive response from you. Thanks

£80 GBP 1 päivässä
(202 arvostelua)

Hi there, I am Python developer, having below given skills: Engineering professional with 5 years of experience in Software development. Mastering/Leading in the development of applications/tools using Python for 5 Lisää

£200 GBP 7 päivässä
(0 arvostelua)

Hello Sir! I am not sure that I can fix that but I have extensive experience in MySQL. IF you give me a chance, I will do my best. It is OKay to don't pay if I don't fix it. :)

£135 GBP 7 päivässä
(0 arvostelua)

How do you choose the records to be deleted? Using a sql select query? or are they all listed one by one?

£278 GBP 5 päivässä
(0 arvostelua)

Hello, there Working as Big Data Engineer /Data Architect in Robert Bosch with 8 years of experience in Hadoop, Hive, NoSQL, Impala, Spark, SQL, ETL, Data Warehousing, Python, Presto, AWS, S3, EMR, Glue, Athena, Azure Lisää

£135 GBP 7 päivässä
(0 arvostelua)

I am having extensive experience in SQL Development, Performance Tuning and Administration. I am ready to work on remote session with you to understand your requirement and fix your issue. Please call me on +9188600713 Lisää

£135 GBP 7 päivässä
(0 arvostelua)