Find Jobs
Hire Freelancers

Advanced SQL Query writing - PIVOT

$30-250 USD

Completed
Posted over 8 years ago

$30-250 USD

Paid on delivery
We need an advanced SQL PIVOT query to pull information from a complex series of table housing information for exams. The table structure and desired output example was loaded to a JSFiddle: [login to view URL]!3/aa66c.
Project ID: 8372408

About the project

9 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi I have been working with MSSQL for over 15 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
$90 USD in 3 days
5.0 (20 reviews)
4.8
4.8
9 freelancers are bidding on average $137 USD for this job
User Avatar
Hi, I have the rich experience in SQL programming. I reviewed the specification and I'm ready to do this task.
$200 USD in 3 days
5.0 (14 reviews)
7.2
7.2
User Avatar
I can do it. .
$100 USD in 3 days
5.0 (24 reviews)
4.6
4.6
User Avatar
Hi, I am 19+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : Oracle,DB2,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Configuration Assistant, Database Migration Assistant,SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN. Let me know when can we discuss.
$155 USD in 3 days
3.8 (29 reviews)
5.4
5.4
User Avatar
SQL Server DBA with 4+ years of experience. I have expertise in creating ssis pacakge, ssrs reports, sql server performance tuning. Project Requirement: SQL Pivot query required Deadline : 1 Day
$155 USD in 1 day
5.0 (2 reviews)
3.5
3.5
User Avatar
Hello!! The job is DONE! Results: ExternalSystemId UserName ExamScore SA15-01 SA15-02 SA15-03 SA15-04 SA15-05 SA15-06 SA15-07 SA15-08 SA15-09 SA15-10 100001 User Name1 100 3 4 3 3 5 3 3 3 3 3 100002 User Name2 90 4 3 3 3 3 3 3 3 2 3 100003 User Name3 80 4 3 3 3 3 3 3 3 3 3 100004 User Name4 70 3 3 3 3 3 3 3 3 3 1 100005 User Name5 60 3 3 3 3 5 3 3 4 3 3
$166 USD in 0 day
5.0 (1 review)
2.1
2.1
User Avatar
Having 10 years of extensive work Exposure on sql server and BI projects. Currently working on Advanced SQL Concepts to accomodate the business proposals and leading the multiple projects and providing the Training on SQL server.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Im an expert in .NET and SQL Server technologies with over tan 20 years of experience in banking sw development I can made a dynamic sql query to match your requirement regards Carlos
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$199 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Chicago, United States
5.0
1
Payment method verified
Member since Aug 31, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.