Sql pivot with 2 aggregates + dynamic column names

Hello, As an expert in sql server & query writing related works, i am very much interested to do this work. Looking forward to have a positive response from you. Thanks

i have ready the code................................................................................................................................................................................................

We are very interested in this project. I have read your above description and i think its well within our range to execute this is in a good time frame so would you be kind enough to message me so we can have a fast and understanding agreement.

I can do this task in 2-3 hrs, because, in the recent projec I have done this kind of development 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

Hi, I am software engineer with 5+ years of experience in .NET technologies (such as: WPF,WCF,WebAPI,SQL etc.), also I have experience in SQL (db modeling, query , triggers, jobs, sp, SSIS) , please take a look to my profile for this project. Thanks in advance, Hovik Aghajanyan

A proposal has not yet been provided

oracle(unpivot): SELECT X.* ,DECODE(ACCOUNTLIST,'ADD_MDIRRACCOUNTID','ODEFF' ,'ADD_MDACCOUNTID','OD' ,'ADD_MDOVERDUEACCOUNTID','OVEROD' ,'ADD_PRCACCOUNTID','PERC' ,'ADD_PRCOVERDUEACCOUNTID','OVERPERC' ,'ADD_COMISACCOUNTID','COMIS' ,'ADD_OVCOMISACCOUNTID','OVERCOMID' ,'ADD_PENALTACCOUNTID','PENALT' ,'ADD_PREMIUMACCOUNTID','PREM' ,'ADD_COMAMORTACCOUNTID','COMAMORT' ,'ADD_OUTRESTACCOUNTID','OUTREST' ,'ADD_EFFMARKETRATEACCID','EFFRATE' ,'ADD_DEFPERCENTACCOUNTID', 'DEFPERC' ,'') as ACTYPE FROM( SELECT ILPC.* FROM DM.IFRSLOANPORTFCNS_DS ILPC WHERE ILPC.datereport=to_date('<!:DATE_END:!>','yyyymmdd') ) UNPIVOT INCLUDE NULLS ( ACCOUNTID FOR ACCOUNTLIST IN (ADD_MDIRRACCOUNTID ,ADD_MDACCOUNTID ,ADD_MDOVERDUEACCOUNTID ,ADD_PRCACCOUNTID ,ADD_PRCOVERDU

I have gone thru the project description and I will be glad to work with you as a SQL developer. I can provide the SQL pivot that you are looking for. About me – I have 10+ years’ experience in software design, development and testing. Have worked on various complex projects across SDLC phases. Have extensive working experience in .Net and SQL/Access database. I am very proactive and responsible developer which has been consistently acknowledged by my clients. Given an opportunity, I will give my best to meet client’s expectations. I am good at keeping stakeholders updated about the status. Looking forward to work with you. Thanks!

A proposal has not yet been provided

Only requirement is just give me what columns you want to have a pivot on as i have a default store procedure with small changes as per your requirement that will work hope so if that is the case it will take less than a day in case any challenges came it mite take a day.

Code examples pivot SET @_strExec = N'INSERT INTO #K_SoTmp (Ngay_Ct ' + @_FieldList + ')' + NCHAR(13) + N'SELECT Ngay_Ct ' + @_FieldList_IsNull + NCHAR(13) + N'FROM (SELECT Ngay_Ct, Tk_Cot, Tien FROM #K_CtTmp) AS tblTmp' + NCHAR(13) + N'PIVOT' + NCHAR(13) + N'(' + NCHAR(13) + N' SUM(Tien)' + NCHAR(13) + N' FOR Tk_Cot IN (' + STUFF(@_FieldList, 1, 1, N'') + N')' + NCHAR(13) + N') AS pv ' + NCHAR(13) + N' ORDER BY pv.Ngay_Ct' EXECUTE(@_strExec)

I am a SQL Server Expert, and could assist you to achieve the task done. As it is a simple request I can assist you in this in future also.

Will get it done asap . Will help in near future too.