MS SQL Query modification

Hi, This will be achieved by pivoting location column. I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Thanks

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. From the query given, I can see that this is a Dynamics GP database, I already have some experience with GP database. Are you going to have a fixed number of locations which can be predefined. The query is possible only if we fix the number of locations (and we can have an others column to accommodate any additional locations). I have placed an hourly rate of $12 but I can assure I wont bill more than 2 hours for this particular task. Thanks Roni

Hi, I am ready to fix this query for you. Let me know once you available . I've over 10 years of programming experience in sql server . Thanks, Hafiz

Professional Experience - Highlights • 8+ years of experience in MS SQL Server development • 6+ years of experience in C# asp.net application development • 4+ years of experience in SSIS development • Health Care, Financial, Renewable Energy and E-Commerce domain • Worked on web applications and windows applications using C#, asp.net, MS SQL server and SSIS technologies. • Developed more than 10 web applications, more than 3 windows applications using c#, asp.net and MS SQL server in Financial, Renewable Energy and E-Commerce domain. • Expert in developing complex store procedures, SQL scripts, efficient triggers, required functions, creating indexes and indexed views for performance. Experience in writing complex SQL queries involving multiple tables inner and outer joins • Experience in monitoring SQL Server Performance tuning, identifying dead locks and resolving them in SQL Server 2008 using SQL Profiler • Expert in designing ETL data flows using SSIS; Worked extensively on ETL process using SSIS package from Excel, Flat Files to SQL Server databases • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging

Hello, I have more than 5 years of experience in web development and very strong skill in MS SQL. I have understood your problem and one solution in my mind. Question: As per screen shown location code is fixed? Thanks-

Hi, I have 5+ years of object-oriented architecture designing, programming and administration experience with success devising software solutions to meet business requirements. - Full-stack developer with C#.NET, Ionic Framework. - HTML5, CSS3 coding - Development of database structures (MS SQL, Access) - Development of ASP.NET website. - Development of desktop applications I will be very reasonable as I believe in long term relationship. If you want me to do this task please contact me.

I have experienced in SQL administration, design and manipulation for more than 6 years. I successfully design and implement the databases for a transportation system, a bus system, and many other systems. I believe I can afford your requirements.

I am expert in SQL, and Oracle Certified Professional. Can do the task as per your requirements. .

I am database administrator , and this is very easy task using pivoting in sql server , i can do it in very less time Thank you

As per you requirement we have a team that will definitely provide best solution to you. We do fair code with reasonable price and client satisfaction is our Responsibility. Personally we have three + years experience of web and desktop based applications using .net framework and Entity frame work and other technology related to this and third party tools as well. There are many running applications on which we have worked and delivered but we have no portfolio because we always focus to deliver support to my client. We have good team of QA (Quality Assurance) so before delivering work our departs make sure that all work is done according to the requirement and flow of the application is 100% accurate. A list of services is provided that our team has been working for the past 3 years and become an expert on. • C# Development • Vb.net • Asp.net • MVC • Web Service (Rest / Soap) • Desktop Application • Crystal Reports • Sql Server Database • Html Css • Javascript JQurey • Angular • Ajax • Java Script • Pretty much anything involves coding

of you want database and query expert then I can give you solution of your query. what's app +91 9427440975

I am senior Sql server developer from last 3 years . I also know ASP.net ,C# since i worked in company from last 3 yaers.. So i am 100% i can handle this task very efficiently

my only question is: Location and quantity is coming from second table(IV00102 A2) right, as per image it seems you have maximum 6 locations? please refer my profile for my past experiences. regards vinay

Hi. I can present you the new form of SQL query to display data for location codes into different separated columns on the result set. For the performance reason the solution will have some stored procedure. Looking for your reply.

HI there,I have READ YOUR Proposal. Hope you are fine as per you requirement we found our self 100% eligible. We specifically work on .net We have a Huge experience in the key skills mentioned below. We promise that we won't let you down. For further discussion related the project please get the touch. Thanx and best regards Infunity Technologies.

I have 7.5 years of extensive experience working in database. In my experience i have worked in migrations and also on implementing complex stored procedures along with database design and development in Sql Server, Oracle and MySQL.

I am working as SQL Developer in a large scale application at Ericsson. I think i am capable of doing the job in the minimum time. I am known for writing efficient programming codes.

Hi, I can modify query but I need in more information. Looking at the picture I am undanstod only that field "QTYCOMTD" is sum of LOC 1, LOC 2 ... thats all.

hi there I have 1 year experience of asp.net with SQL server and 6 month of SQL server reporting service. I can do this work for you thanks

Hi, I know what you are asking for. I already build a university management system with more than 24 modules so I can complete your project in very efficient way that other cannot. Modules I built for university management system are: Student Admission, Student attendance, student leave management system, exam, result, timetable, class management, fee management, accounts, finance, HRM, HR Recruitment system, Employee Attendance, Employee Leave, inventory, library, transport, student portal, parents portal, staff portal student administration, Mobile integration, SMS Alerts, Emails, Biometrics etc. I will not only work for you but will also provide you more ideas and solutions so you can improve your project and knowledge. I have more than 7+ years of experience in asp.net and SQL. I already done dozens of projects. I am specialized and have experience to accomplish that project successfully.