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

Befejezett Kiadva: 6 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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.

Adatbázis-programozás Microsoft SQL Szerver SQL

Projektazonosító: #15480154

A projektről

50 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 évvel ezelőtt

Odaítélve:

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 Továbbiak

$200 USD 3 napon belül
(295 értékelés)
7.9

50 szabadúszó tett átlagosan 166$ összegű árajánlatot erre a munkára

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 Továbbiak

$166 USD 1 napon belül
(52 vélemény)
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 Továbbiak

$300 USD 5 napon belül
(77 vélemény)
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 Továbbiak

$200 USD 3 napon belül
(39 vélemény)
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 Továbbiak

$155 USD 2 napon belül
(24 vélemény)
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 3 napon belül
(18 vélemény)
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 Továbbiak

$100 USD 3 napon belül
(35 vélemény)
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 3 napon belül
(45 vélemény)
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 Továbbiak

$250 USD 3 napon belül
(9 vélemény)
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 5 napon belül
(7 vélemény)
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 Továbbiak

$125 USD 3 napon belül
(25 vélemény)
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 Továbbiak

$80 USD 3 napon belül
(19 vélemény)
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 Továbbiak

$240 USD 10 napon belül
(3 vélemény)
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 1 napon belül
(2 vélemény)
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 Továbbiak

$98 USD 3 napon belül
(13 vélemény)
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 3 napon belül
(5 vélemény)
3.5
Lultu

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

$188 USD 3 napon belül
(4 vélemény)
3.1
ihshsl

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

$111 USD 2 napon belül
(2 vélemény)
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 Továbbiak

$150 USD 2 napon belül
(0 vélemény)
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 Továbbiak

$166 USD 15 napon belül
(0 vélemény)
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 5 napon belül
(0 vélemény)
0.0