Create stored procedure to delete all depending records (T-SQL, SQL Server)

Completado Publicado hace 6 años Pagado a la entrega
Completado Pagado a la entrega

I need a stored procedure to delete all records that are related directly or indirectly to a root table by foreign key relationships. The database has around 110 tables.

The script cannot be created automatically because of cycles in the relationships. Therefore, the tables must be analyzed individually.

The root table contains the company name resp. company id. I need to delete all records related to this company.

Provided material:

- SQL Database with data (Version: SQL Server 2008)

Expected result:

- Stored procedure that I can call with the CompanyID.

- After execution, all related records and the root table records have been deleted

The project must be completed by Thursday October 31st, 2017 24:00 UTC.

There will be two milestones:

- milestone #1: stored procedure is delivered

- milestone #2: stored procedure has been successfully tested

Please note:
- the database structure must not be changed (resp. the database structure before and after the deletion must be identical)
- Only data related to the selected company may be deleted. No data related to other companies may be deleted. The data is organised hierarchically with the company as its root.

Programación de bases de datos Servidor de Microsoft SQL SQL

Nº del proyecto: #15480154

Sobre el proyecto

50 propuestas Proyecto remoto Activo hace 6 años

Adjudicado a:

sumon355

Hello, As an expert in writing complex sql statements specially in ms sql server, i am very much interested to do this project. Looking forward to have a positive response from you. I am still okay with your update Más

$200 USD en 3 días
(295 comentarios)
7.9

50 freelancers están ofertando un promedio de $166 por este trabajo

feninsoftech

This task is to create a stored procedure to delete all child table data and then parent table data for a Company. Relevant Skills and Experience I have 10 years experience in SQL Server development. I have expertise Más

$166 USD en 1 día
(52 comentarios)
6.9
mpalgeo

Hi , I will create a sp which automatically detect the relationship between the tables and delete accordingly. With that approach it will be no need to make any changes in the sp if you make any changes to the DB. exc Más

$300 USD en 5 días
(77 comentarios)
6.4
hardikshah83

I am a programmer with more than 12 year's experience in SQL database. I can complete this task within 48 hours. Relevant Skills and Experience Let's discuss and make this project a success. Proposed Milestones $100 Más

$200 USD en 3 días
(39 comentarios)
6.0
SergioAlfaroV

I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I am also a near-native English speaker. Relevant Skills and Experience SQL Server: Advanced Más

$155 USD en 2 días
(24 comentarios)
6.0
zu02

Hi, I can code that procedure. Relevant Skills and Experience ms Access/Excel/VB/SQL programmer since Ms Office 97 released Proposed Milestones $250 USD - default

$250 USD en 3 días
(18 comentarios)
5.7
AliSafder

I can work and deliver stored procedure as per your requirements. I shall be needing one meeting to discuss and then I can work on Stored Procedure. Relevant Skills and Experience I have 9 years of SQL Server Develop Más

$100 USD en 3 días
(35 comentarios)
4.9
vinaysinghh

i am sql server dba having more then 10 yrs of exp Relevant Skills and Experience sql Proposed Milestones $111 USD - sql

$111 USD en 3 días
(45 comentarios)
5.0
IMExpertEngineer

Hi, I'm expert sql server DBA and I can do this job very well. please share the database with data so that I could start work on this job. Thanks Relevant Skills and Experience sql server Proposed Milestones $250 U Más

$250 USD en 3 días
(9 comentarios)
4.8
i2software

hi. my name is pablo. i'm work about 10 years develping sp backend for banking systems. i can do the work.

$166 USD en 5 días
(7 comentarios)
5.2
bhupen2606

Hello, i have extensive experience in creating stored procedures on SQL Server. i have understood your requirement. I think, i'll be able to provide you the required stored procedure. Relevant Skills and Experience Sq Más

$125 USD en 3 días
(25 comentarios)
4.3
sheikDev

Hello, Im interested to work on this. I got the requirement and ready to work and create a procedure. Relevant Skills and Experience 10 years experience in .NET and SQL. Proposed Milestones $55 USD - delivery $25 US Más

$80 USD en 3 días
(19 comentarios)
4.3
Splaszczyk

TASK NOT AS EASY as seem to be. Easiest way would be to change / set all foreign key with ON DELETE CASCADE option, however it this is not allowed (?) there are also some other options ... Odpowiednie Umiejętności i Más

$240 USD en 10 días
(3 comentarios)
4.4
UmidKZ

Hi, ready to take this project immediately, will deliver stored procedure within 1 day. Соответствующие навыки и опыт MS SQL Server, T-SQL Предлагаемые промежуточные платежи $138 USD - Full delivery of the project

$138 USD en 1 día
(2 comentarios)
3.5
AntonBliznetc

You need stored procedure delete info about company base on ComplanyId Relevant Skills and Experience I have 20 year exp use sql include mssql Proposed Milestones $48 USD - stored procedure is delivered $50 USD - st Más

$98 USD en 3 días
(13 comentarios)
3.5
bilalmaher053

hi, i am a software engineer and expert in SQL and i can create store procedure for u, can we discus more in PM? Stay tuned, I'm still working on this proposal.

$100 USD en 3 días
(5 comentarios)
3.5
Lultu

Having 12+ yrs exp with SQL Relevant Skills and Experience SQL.,MySQL, PHP, Coldfusion Lets discuss

$188 USD en 3 días
(4 comentarios)
3.1
ihshsl

. Relevant Skills and Experience , Proposed Milestones $111 USD - . .

$111 USD en 2 días
(2 comentarios)
2.1
tbrifki64

To create a SQL script functioning as stored procedure to delete all records in sets of related tables Relevant Skills and Experience I code SQL, mainly in MS SQL Server platforms Proposed Milestones $50 USD - Script Más

$150 USD en 2 días
(0 comentarios)
0.0
mnady

Hello, I am a veteran developer and freelancer with vast experience in SQL server and data-driven apps. please review my profile in upwork (look for Michael Nady), I did SQL server tests there and scored high above ave Más

$166 USD en 15 días
(0 comentarios)
0.0
kunalneeli

Hello, I am an experienced professional in Oracle, MySQL and some experience in SQL server. I have created similar stored procedure and packages in Oracle for a client Regards.

$166 USD en 5 días
(0 comentarios)
0.0