Build a SQL Stored Procedure

Hello there, to do the job as you required the first thing i have in mind is need to make it dynamically, that means we should have a couple of meta data table such as: table to remove from, table of the life cycle of the data base on the date column on that table we want to delete. All of the thing we need to do is design the control tables and the last thing is to write a stored procedure to read the meta data from those control tables and then execute everything (deleting) as we want. I would like to share more about this idea with you because i've done many dynamical job like this before. Waiting for your response if interested. Thank you!!! P.S: To read the FK we need to go through Information_schema to get it....

Since 2010 I am working on SQL database systems on MSSQL or MySQL to design and build database systems. So more than 10(ten) years of experience in SQL. If you want a good delivery of work, then message me, please.

Summary ------- # 15+ years of experience in database design, development and administration # 5+ years of experience as an independent (freelance) consultant # 35+ database centric projects # Certified by Microsoft, MongoDB, HP, EnterpriseDB, Oracle, AXELOS, EXIN # Troubleshoot and fix database issues (L2 and L3) Top Qualities ------------- # Straight talk # Simplest possible solution for complex problems # Challenge accepted equals to (=) challenge completed Tech. Roles ----------- # Data Architect # Database Administrator # Database Consultant Tech. Skills ------------ # Primary: SQL Server (2000 and later), T-SQL # Secondary: Oracle, MySQL, PostgreSQL, MongoDB, Vertica, Erwin # Other: Windows, Linux, AWS, Azure Work Experience --------------- # Principal Database Consultant @ Dhanu IT Services [Sep 2013 - Present] # DBA & Data Architect @ Many [Jun 2004 - Sep 2013] Work Preference --------------- # Type: Permanent, contract # Location: Remote, work from home # Commitment: Full time, part time, hourly, fixed scope # Time Zone: Any, India Standard Time (preferred) # Language: English, Hindi #DhanuIT #DhanuDBA #DhanuDEV #DhanuARC #DhanuEVL

Hey, I have good experience in SQL database administration and worked on creating data warehouses by integrating different data sources. Please initiate chat to discuss further.

Hi I have 15 years of experience in SQL server Database development MySQL development,postgress SQL server Database developments,postgress sql server Database development, C#, Python, powershell and power bi. I will be able to help you with the project. Please ping me offline to discuss further.

Hello Andrew D. Greetings of the day! I read your description and have rich experience in SQL and Microsoft SQL server so i can finish your project in short time I’m looking forward to hearing from you soon. Thank you for considering my cover letter. Marko

Hi, I have over 10 years experience in SQL Queries, Stored Procedures and Functions in MS SQL and MySQL. I already wrote a stored procedure to downsample time series data. As a administrator of big size databases (>1TB), I'm really interested to do your job. Let's Chat and talk about it.

Hi There, I can write this procedure for you. I would need an export of the DB schema to refer to the keys. And I will use system tables too. I can finish this work in a week's time. And I will give you a fully working and tested stored procedure. You may me once I deliver the code with proper test results and screenshots. A bit about me - I am a database developer with over 14 years of experience in database design, programming and optimization. I am from Europe and I work in CET(Paris/Brussels) time-zone. I am not affiliated to any consultancy firms and I work independently. I look forward to your response in this regard. Salutations/Met Vriendelijke Groeten/Kind Regards Paul

Hi, I've read your description carefully. I have full experience with Database I've also worked on several similar projects. So I can complete your project with high quality on time. Looking forward to hear more about the project from you via chatting. Thanks & Best regards!

Hi, I hope you are doing good. I have 8 years experience in SQL server. You can use my services I am waiting your swift response. thanks

I am SQL server developer having more than 6 years of actual industry experience. Proficient in delivering high performance complex T SQL scripts. I will be happy to help you after completion of the project if you have any issues with the code. Still i need to see the actual requirements then I will commit the dead line. please provide additional information on the same.

Hey there, I have 4 years of working experience in web technologies and I have a strong working knowledge of every possible framework which is in the market. In terms of client-end I know: Database Administration, Microsoft SQL Server and SQL Also I have done tons of work on freelancing career. I am waiting anxiously for a positive response from your side. And I have read your requirements as well. Thanks and regards, Shamshad

Hi. I have rich experience in MySQL/MSSQL/Mongoose/SQLite and other databases. Especially I have good knowledge about SQL queries. Looking forward to having a long-term relationship with you. Hope to discuss more details via private chat. Regards. Vadym K.

Hi, I hope you are well. I am very interested in your project. To complete your project the table need to 5th standard structured I have solid skills and full experience in MySQL, Postregs, MongoDB, Firebase etc Also I have full experience about various hosting services such as aws ec2, azure, digital ocean and so on. So if you could share your detail with me, I will do my best. I am looking forward to hearing positive response from you. Thanks.

Hi Andrew. How's it going? I have checked your requirements carefully. I can support you. I have rich experience in SQL and database management. If you are interesting me, feel free to contact me anytime. I can start work right now. Thanks, Valentin Volkov.

Hello, Andrew. I have read the above requirements for the SQL statement you want and I can write such a SQL statement. I have more than 3 years of rich DBMS development experience and have successfully developed IMDBMS (In Memory DBMS). I can deliver good result to tight deadlines. I'm interested to hear more about the project and about the subject matter of the project. I can start working right now. If you award me the project, I'd be very happy to discuss this further and get started for you as soon as possible. Feel free to contact me via chat. Thanks & Best regards! Nazar.

I have 9 years of experience using MySQL and SQL server. I have written similar purging logics in MySQL database so, I am aware of the complications that it entails.

Hello, 13+ years experience in script programming with oracle tools. You will definitely get best results by allowing me to do this job. Thanks a lot.

I have more than 14 years of IT experience with Database Implementations / Development / Database Performance Tuning and R&D / Software Development / Database Administration / Data Visualisation. I specialise on building premium, efficient and high-performance database models and designs, designing data warehouses and performance tuning across RDBMS Platforms (POSTGRES /MS-SQL/ MySQL /Oracle ). I help my clients build systems that are scalable, efficient and high performant and to make the right decisions on technology/implementations so that they achieve better user experience and save on resource/hardware/development costs. Expertise in developing skill , proficient in PLPG-SQL,T-SQL writing stored procedures, triggers and functions. Worked in build complex query. Database tuning experience. Good written and client interaction skills at all management level. Energetic self-starter and can learn new technology in short time. Tuning query performance and recommending better way to optimize SQL queries and pl-pgsql/T SQL programs Having Developing/DBA experience of postgres database size more than 10 TB.

I can do it well bases on my knowledge and experience for many years. Sure that your project can finish verry well as you want. Please, contact with me when you are available. Many thanks