Completado

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

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.

Habilidades: Programación de bases de datos, Servidor de Microsoft SQL , SQL

Ver más: stored procedure to delete data from table in oracle, how to delete records with foreign key constraint in sql server, how to delete rows in tables that contain foreign keys to other tables, sql delete row with foreign key constraint, how to use cascade delete in sql, stored procedure to delete records from multiple tables, how to write delete query in stored procedure in sql, stored procedure to delete data from table in sql server, stored procedure add multiple records child table, create stored procedure derby, create stored procedure postgresql, derby create stored procedure, create stored procedure following accepts parameter job_title_code, sql server management studio create stored procedure, create stored procedure copy data tables sql2005

Información del empleador:
( 5 comentarios ) Bern, Switzerland

Nº del proyecto: #15480154

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
(172 comentarios)
7.2

53 freelancers están ofertando el promedio de $164 para este trabajo

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
(73 comentarios)
6.2
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
(40 comentarios)
6.0
mahmoudgamal008

I have more than 5 years of professional and practical experience in SQL Server, TSQL and database development. Relevant Skills and Experience I wrote hundreds and hundreds of SQL queries. I have more than 1800 answe Más

$200 USD en 3 días
(39 comentarios)
5.7
AndrejStastny

Hello, I am an expert of MS SQL Server. I have done very good T-SQL script recently. Also I have written this kind of script avoiding DISCARD at my previous work. (It was full 7 pages of script) Please look at my rec Más

$250 USD en 2 días
(17 comentarios)
5.2
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
(21 comentarios)
5.3
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
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
(4 comentarios)
4.9
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
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
(25 comentarios)
4.5
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
(12 comentarios)
5.4
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
(42 comentarios)
4.9
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
(19 comentarios)
4.2
dhanuitdevendra

We can help you with our Database Developer as a Service (DEVaaS). Please visit [url removed, login to view] for details. Relevant Skills and Experience Please have a look at our existing customer base (http://ww Más

$200 USD en 1 día
(5 comentarios)
4.3
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
(8 comentarios)
4.4
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
(14 comentarios)
3.9
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
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
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
(3 comentarios)
2.7
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
(8 comentarios)
2.4
$155 USD en 3 días
(3 comentarios)
2.3