Create stored procedure to delete all depending records (T-SQL, SQL Server)
$30-250 USD
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.
Nº del proyecto: #15480154
Sobre el proyecto
50 freelancers están ofertando un promedio de $166 por este trabajo
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
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
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
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
i am sql server dba having more then 10 yrs of exp Relevant Skills and Experience sql Proposed Milestones $111 USD - sql
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
hi. my name is pablo. i'm work about 10 years develping sp backend for banking systems. i can do the work.
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
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
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
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
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.
Having 12+ yrs exp with SQL Relevant Skills and Experience SQL.,MySQL, PHP, Coldfusion Lets discuss
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.