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.

Навыки: SQL-сервер Microsoft, Java, MySQL

Показать больше: 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

О работодателе:
( 6 отзыв(-а, -ов) ) Belfast, United Kingdom

ID проекта: #30182308

7 фрилансеров(-а) готовы выполнить эту работу в среднем за £173

(683 отзывов(-а))

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 день
(202 отзывов(-а))

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 Больше

£200 GBP за 7 дней(-я)
(0 отзывов(-а))

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 дней(-я)
(0 отзывов(-а))

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 дней(-я)
(0 отзывов(-а))

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 Больше

£135 GBP за 7 дней(-я)
(0 отзывов(-а))

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 Больше

£135 GBP за 7 дней(-я)
(0 отзывов(-а))