SQL Stored Procedure for DB Management

Please provide some details about the existing frontend functionality that needs to be mirrored using SQL based Stored procedure. -->Have more than 14 years of experience in Windows software development -->Have been working on SQL Server since 2010.. Created complex Stored procedures,Triggers , Functions, Custom XML based Pivot queries in Stored procedure etc. Looking forward to have a chat with you to discuss further.

Hi there! With over 12 years of experience in software engineering on large and complex projects, I'm sure I can help you finish your project with ease. I have an extensive experience in the following areas: - Software architecture - Distributed systems - Database modeling - API design - CI/CD Some of my specialties are: • .NET 8, Web APIs, SignalR, Entity Framework Core, Dapper • Angular, TailwindCSS, ReactJS, JavaScript, TypeScript . Telerik, DevExpress, AspNet Zero • C#, C++, Rust • PostgreSQL, MS SQL Server, MongoDB, Redis • RabbitMQ, Amazon SQS, Kafka, MassTransit • Azure, AWS

Hello, Full stack web developer, with 16+ years of experience in ASP.NET Core, Blazor, Angular, Reactjs, Nodejs, ASP.NET MVC, Azure. AWS Apis, C# web forms, VB.NET, Classic ASP, Vbscript, SQL Server, HTML, CSS, javascript, jQuery, JSON and XML. Handled various integration-based projects, product-based projects, and CMS-based projects.

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

Hi there, ★★★ Database Design & Development Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to create a stored procedure that will automate the process of marking certain items as 'picked up'. I have completed multiple projects across various domains like Manufacturing, Inventory Management and Vehicle Monitoring System. I do have strong SQL and Excel expertise, through which I will be able to provide you standard and professional way of solutions to your requirements. Services I offer: ✔️ ER, EER Diagrams ✔️ Database creation(Tables, Views, etc) ✔️ Database Design(Normalization, Constraints, etc) ✔️ Programming(Joins/Triggers/Sub queries/Functions/Operators/Views/Sequence) ✔️ Database Modeling, Standardisation ✔️ Bug Detection & Fixing ✔️ Data Security ✔️ Group and sort ✔️ Excel macros, formula ✔️ Data import/export/backup/restore (any format) Databases I work on: ✔️ Oracle ✔️ MySQL ✔️ MS SQL Server ✔️ MS Access ✔️ Sqlite ✔️ NoSQL ✔️ MongoDB As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

True SQL Procedure Expert is here , I am working with SQL server 25 years , any any complex SP not issue for me , depending on Store Procedure Total task or complexity i can give you final offer and timeline

Hi there! I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..

Respected Sir, Greetings of the Day ! I am Udal Bharti. I have 10+ years of competitive experience in web application development using .net, Oracle and SQL server. I have 9+ years of experience in Database development & management and i am expert in writing complex queries, stored procedure, User Defined Functions. My Skills ------------------- 1. Extensive Experience in writing complex queries 2. Expert in Writing Stored Procedures, Triggers, User Defined Fucntions 3. Expert in Creating and managing Jobs 4. Expert in SSRS If I can provide you with any further information on our background and qualifications ,Please let me know. I look forward to hearing from you , Thank you for your consideration. Regards Udal Bharti

***** .Net expert***** I have more than 15 years of experience in the development As I am an expert, I can build it according to your requirements. Because I have a lot of experience in these fields, I can build your project as soon as possible. I offer excellent software quality work and provide the best support for your project. If you give me this job, I will do my best to finish your job by your timeline. If you want to see my past works, I can show you my past works right now. Ready to discuss this with you about the task now. Thank you for the reading.

Hi, I am a Full stack developer in Microsoft technologies.  I have vast experience on working on projects that suits your requirement exactly. You can check the reviews in my profile regarding the same. My area of expertise is web application development (Web API, ASP.Net web forms, MVC, classic ASP), Web Development ( Blazor, Angular) , web services (SOAP & RESTFul), MySql & Sql Server as back end (through stored procedures).  I have 10 years of experience as a full time software developer.  Kindly contact me, lets discuss your requirements.

Dear Nishi G, With extensive experience spanning 15 years in databases, I'm an expert in database design, SQL scripting, and data analytics – just what you need for this project. I am well-versed in Microsoft SQL Server and have a solid understanding of Windows application development too, which would be crucial in ensuring that the script closely matches the behavior of your existing front-end tool. Moreover, I've had significant hands-on experience in creating SQL stored procedures for automating database actions. Rest assured, I will keep you updated throughout the development process and deliver a fully tested solution, meeting and exceeding your expectations. I eagerly anticipate the opportunity to discuss the project details further and am available at your convenience. Warm regards, Saima

I have good experience in writing SQL stored procedures. We can write a procedure and schedule it to run so that the process will be automated. Please initiate chat to discuss further.

I can help you with sql queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create powershell queries for server as per design, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated again, send the details for the project. Please contact me asap. I have 12+ years of experience in database programming, website designing, powershell scripting and android development. Feel free to message me anytime if you need to discuss this further

Hi, Can you provide more details about the specific functionality of the Windows application that you want to replicate with this stored procedure? Could you provide insights into the structure of the relevant tables in the Microsoft SQL Server database? Which tables and columns are involved in tracking the status of items? Let's connect to discuss this in detail. Greetings Abhishek

Hi there, I am a Data Scientist and a professional responsible for extracting actionable insights and knowledge from large volumes of Database Development. I can write clean Database code: Access, MySQL / PostgreSQL / NoSQL ( MongoDB, DynamoDB ) Database: Access, MySQL / PostgreSQL / NoSQL ( MongoDB, DynamoDB ) My top priority is to provide high-quality work; I am willing to devote my time and energy to fully improve the service offered with timely, accurate, and professional results, building trust and a long-term relationship with customers is my main objective. https://www.freelancer.com/u/GdevDataScience Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev

Hello, I am a professional WEB and MOBILE developer with 10+ years of experience. I will provide you 100% quality work. Looking forward to hearing from you. Best regards!

Good day! I'm not quite sure of the extent/functionality needed to be replicated. What is the criteria upon which we should mark the records on? Will we hard-code the criteria or there will be input from the user? How much functionality needed really? Will the stored procedure be executed by a DBA using a SQL query or there will be a client application calling the stored procedure and you simple want to move the "business logic" to the stored procedure to be able to modify in the future without recompiling? Those are so many questions that need answering, I would really appreciate it that, if you decide to choose me, ping me on chat to discuss further so I can adjust my bidding accordingly. I have over 13 years of experience with Microsoft SQL Server development and Windows development, using Microsoft .NET, C++ with Win32 API and MFC. You may have a look at the "Catalyst HMS" project in my portfolio, which is based on Microsoft SQL Server and makes extensive use of stored procedures. Mustafa

hi, i have many experience working with stored procedures for diferent scenarios so i h¿can help you with tis problem, aditionaly i have 10 years of experience with net core and sql server, please contact me

With over 15 years of extensive experience in SQL Server database modeling, design, development, and administration, I bring a wealth of knowledge to efficiently tackle complex business challenges. Throughout my career, I have honed my skills in T-SQL, adeptly writing intricate scripts, stored procedures, functions, and triggers. My expertise extends to performance tuning, encompassing index utilization, JOIN optimization, dynamic query construction, and proficient use of CTEs, temporary tables, and table variables. I have had the privilege of collaborating with prominent clients on Business Intelligence initiatives, specializing in SSIS, SSRS, and SSAS. My contributions include the creation of diverse workflow packages and insightful reports. Additionally, I have played a pivotal role in designing data warehouses for OLTP systems. Operating within 24/7 support environments, I have managed medium to large mission-critical databases, ensuring optimal performance and reliability. My responsibilities have encompassed performance monitoring, log file maintenance, deadlock and blocking resolution, disk space management, job monitoring, failure handling, as well as implementing robust backup and recovery processes for disaster management.

With my significant experience and deep understanding of Microsoft SQL Server, your project falls squarely within my area of expertise. I have a thorough appreciation for automating database management processes and assuredly deliver innovative solutions to streamline operations, save time, and reduce potential errors. Over the years, I have developed numerous SQL stored procedures for various tasks including mirroring behaviors of existing front tools - thus, handling your request skillfully is a given. In addition to streamlining database management, I am adept in data visualization tools such as Power BI and Looker. With this proficiency, I can ensure the changes made by the stored procedure are rendered into clear and actionable insights. Combining this with my cloud services knowledge including the likes of Google BigQuery and Oracle Cloud Infrastructure (OCI), I guarantee not only quick yet precise results but also optimized performance. Finally, as an excellent communicator and perceptive collaborator, I will work closely with you throughout the project, providing timely updates on progress while seeking your input where needed. Let’s harmonize my expertise with your hands-on guidance to create an innovative SQL solution that effectively matches your needs. Allow me to streamline your database management process to greater efficiency and ease.