MSSQL Pivot, need row total column

Hi Bob, I did see the desired output as you want is the columns for each month of the year and the total, the thing I'm confused is when you have 12 months assume from 01-2022 to 12-2022 the total should be the sum of all from 01-2022 to 12-2022 but in case you have data from 01-2022 to 06-2023. Should we split into 2 total such as: total-2022 and total-2023. Of course those total will be dynamic too. If you have the data expand in 3 years we should have 3 total columns instead of one. Waiting for your response if interested. Thank you!!!

Hi, my name is Ketan and I am an experienced Full Stack Sr. Software Professionals team. We have worked on many web projects and provide services such as software development, systems integration, testing and assessments. I noticed that you are looking for a developer to modify an existing SQL statement that uses a pivot and needs the last column to contain a sum of all the columns. We specialize in working with MSSQL so we are confident that we can deliver a successful solution for this project. Our skills include ReactJs, .Net Core, .Net MVC, ASPBOILERPLATE, ASP ZERO, Angular (13, 9,8), Js, C# .Net, EF Core and more. Additionally we have experience working with dynamic column names so your project needs should be accommodated during the course of the project.

Well. I am pro when it comes to PIVOT table concept. Brief About Me: I am a "Full-Time" Individual freelancer having 15+ years of expertise over MS Technologies(C#). Apart from having relevant technical skills, I have good analytic skills and strong grasping power. I have 10~ years of experience of working as a full time freelancer and in that span I have worked over various Windows, Web and Mobile Projects ranging over various domains in different sub technologies.

I just checked your 4 attachment file with output you desired , and i assure you i can deliver it 100% accuracy as per your desired. i am 25 years database expert and already my analysis done with your SQL. can you confirm me so that i can start work for you

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within some hours

Hi Bob, Hope you are doing fine. I understand your requirement for modifying an existing MSSQL statement that utilizes a pivot operation. The specific modification involves adding a final column that displays the sum of all the row's columns. Notably, the column names are dynamic, necessitating a flexible solution. I assure you of my expertise in MSSQL development and my commitment to delivering a high-quality solution. Key Development Capabilities:- NopCommerce | Power Apps | DotNet Core | MVC | NodeJs | ReactJs | Angular | JQuery | LINQ | Javascript | Blazor | Flutter | Python VB.Net | C#.Net Restful APIs | Web APIs PowerApps | Tableau | Power BI SQLite | MySQL MongoDB | PostgreSQL MS SQL Server | SSRS | SSIS | ETL | Microsoft Azure | AWS | AWS Lambda | MS Access Oracle Crystal Reports Reporting Services (RDLC) Let's have a discussion and proceed accordingly.

Good Morning/Afternoon/Evening! I can help you to modify the existing SQL Script as per your business needs. I've 8+ years of exceptional knowledge and experience in both SQL Server Prod & Dev environments. Thank you for considering my proposal. I'm genuinely excited about the possibility of working together. Whether you've any questions or are ready to discuss further, please feel free to reach out. Best regards, Kundan Bihari

Hi there, ★★★ Database Design & Development Expert ★★★ 10+ Years of Experience ★★★ I've read requirements and ready to modify an existing SQL statement that uses a pivot.. 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

⭐⭐⭐⭐⭐ Hi there, I am full stack developer with 7+ years of experience in website and desktop app development with Oracle, MySQL, MariaDB, SQL Server, PostgreSQL, MongoDB and more. I have strong expertise in Database design, Database modeling, SQL, PLSQL, Dynamic queries, pivot tables, Stored Procedures, Functions, Database Normalization, UML, ER Diagrams, Rational Schemas, Data dictionary and more. I have checked the attached files, an easy job for me. Have a look at my profile for my portfolio and similar projects I've completed with reviews. Message me, I would like to discuss further details over chat.

My name is Yaroslav and I am an experienced MSSQL developer with over 8 years of software development experience. I have the necessary skills and knowledge to complete your project. Specifically, I have expertise in SQL, which would be essential for analyzing the data required for the operation, as well as in building solutions that accommodate dynamic column names. Additionally, I am proficient in various platforms, languages, and embedded systems which would be useful for building the solution required for this project. I am confident that I can deliver quality results within a week timeframe. Please feel free to reach out if you would like to discuss further or need any additional information.

Hello, I am Akmal Shahbaz and I am an experienced MSSQL developer with strong skills in writing. I completed a Ph.D. with focus on writing, so I have the necessary skills to understand your project description and complete your request. I have experience working with MSSQL specifically related to pivots that use a last column summing up all columns. Specifically, all data required for the operation is available, so there is no problem with that. The project needs to be completed within a week to make sure you get the results you need fast enough. I believe I am the best fit for this project due to my extensive experience in Microsoft SQL Server and other related technologies as well as my expertise in SQL Pivot and summing up columns. Please feel free to reach out if you have any questions or would like more information about me or my services.

Hello! My name is Rajeev and I am an experienced .NET developer. With 10 years of experience in the field, I have a deep understanding of the framework and its libraries. I understand that you are looking for an experienced MSSQL developer to modify an existing SQL statement that uses a pivot. Specifically, you need the last column to contain a sum all of those row's columns. All column names are dynamic so the solution needs to accommodate them as well. I would be delighted to help you with your project! I have the skills required to complete this task within a week's timeframe. My expertise includes Microsoft SQL Server and I am confident that I can provide the highest quality output for your needs. Please let me know if you would like me to discuss further or if you have any other questions? Thank you for your consideration!

Hi!, I am writing to express my interest in the MSSQL Pivot, need row total column . I am a senior business consultant with over 15 years of experience in creating and managing Microsoft SQL Server and SQL. I have a proven track record of success in delivering high-quality, accurate, and timely Microsoft SQL Server and SQL. I am confident that I have the skills and experience necessary to successfully complete your Hello, I am looking for an experienced MSSQL developer to modify an existing SQL statement that uses a pivot project. I am eager to learn more about the project and discuss how I can contribute to your success. Thank you for your time and consideration. Sincerely,

Hello, I am Baber, a highly qualified, experienced and efficient Microsoft SQL Server developer. I understand that you need the last column to contain a sum of all those rows' columns and all column names must be dynamic so the solution needs to accommodate that too. I can help you with your project. With my skills and experience I can complete this task within a week. specifically for this project, I have the necessary knowledge and experience in MSSQL and other related technologies such as Android SDK (Java & Kotlin), iOS SDK (Objective-C & Swift), Java, C# ASP.NET REST APIs (Retrofit & Alamofire), Bluetooth Classic & Low Energy NDK & JNI Python (Keras & Tensorflow) as well as design work. Additionally, I provide customer satisfaction on a weekly basis as well as optimal quality in all my projects.

Hi, I have advance excel vba programming. Excel programming is my passion and I would really solve your problems in excel and save your time by creating Macros , VBA programs , user forms , Pivot table, Access Database ,data analysis, dashboard and so on... I provide services in below areas VBA programming Macros Formulas (Simple and Complex) Automation Pivot Table Dashboards Forms Reports Microsoft Access Power Bi Power Pivot Sql Others...

Hello, Robert! I just read job description carefully and noticed that you are looking for a professional web developer with rich experiences in MSSQL. As I have expertise and rich experience in this field, so your project attracts me. I'd like to discuss your project on chatting so we can get clear idea with each other. Best regards

Hello Robert S., I hope this message finds you well. My name is Christopher, and I am a SQL expert with over 4 years of experience. I have carefully read your project requirements and I am confident that I can deliver the desired results with perfection. I have extensive experience working with MSSQL and I am well-versed in handling pivot operations. I understand that you need to modify an existing SQL statement to include a row total column. I assure you that I can efficiently modify the statement to meet your requirements. Additionally, I am comfortable working with dynamic column names, ensuring a flexible and adaptable solution. If you have any specific questions or would like to discuss the project in more detail, please feel free to connect with me in the chat. I am available to address any concerns or queries you may have. Thank you for considering my proposal. I look forward to the opportunity to work with you on this project. Best regards, Christopher

Hello, I am Azubuike, a experienced MSSQL developer with 10 years of experiences in marketing and business analytics. I understand you are looking for an experienced MSSQL developer to modify an existing SQL statement that uses a pivot to get the last column to contain a sum of all those rows' columns. All column names are dynamic so the solution needs to accommodate them too. I can definitely help you with this project! My skills include SQL and I am confident that I can provide the solution you are looking for within a week's time frame at no additional cost to you. Please let me know if you would like me to discuss further or if there is anything else you would like to know about me or my skillset.

Hello, I am Hafiz Abdul, a professional python developer with extensive experience in web development, web scraping, machine learning and deep learning. I have successfully completed numerous projects for different clients and I would be delighted to work on your project. I understand from the description that you need the last column to contain a sum of all those rows' columns. With my expertise in SQL Server, I can complete this project within a week by modifying an existing SQL statement that uses a pivot. I love to work on projects that require deep understanding of technologies as well as quick response time. If you are looking for an experienced MSSQL developer who can deliver quality results within a week then please feel free to contact me. Thank you for considering me for this project! Regards, Abdul

Hello Bob, I have read your job description and having expertise in MS Sql Server. I have 7+ years of experience in software development field. you can get a free demo of my work for your project before getting hired and I can start work immediately. I look forward to your response. Thanks, Pradeep

Hi, I checked your requirement, I can work on it. I have Experience in below technical work. 1. Power Bi Desktop & Services With DAX, Power Editor 2. Excel VBA, 3. Power Query, Power Pivot 4. Advance Excel, 5. Excel Dashboard dynamically with VBA Codes. Knowledge About Power Automate, SQL, MS Access with VBA etc. For More Details Check my Portfolio's Sample Dashboards. With Best Regards, Data Analyst/Power bi Specilist