Need a simple PIVOT query for some SQL data

$10-30 USD

Completed

Posted

almost 5 years ago

$10-30 USD

Paid on delivery

I need a really simple PIVOT query for some data, something that turns data like this: SELECT ID, Type, Count(Type) FROM MyTable ORDER BY ID, Type ID Type Count 101 TypeOne 4 101 TypeTwo 2 101 TypeThree 1 Into ID TypeOne TypeTwo TypeThree TypeFour 101 4 2 1 0 This is the simplest example of a PIVOT, I'm trying to wrap my head around it.

Microsoft SQL Server

SQL

Project ID: 19982455

About the project

4 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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:

@sumon355

Hello, As an expert in SQL, i can write the required query for this purpose. I guess you are using ms sql server, right. Looking forward to have a positive response from you. Question: Is Type1-Type4 fixed for this data? Thanks

$19 USD in 0 day

5.0

(237 reviews)

7.6

4 freelancers are bidding on average $18 USD for this job

@mazharsahil12

Hello sir I'm professional sql developer having 5 years of experience please contact me........ ....

$15 USD in 1 day

5.0

(12 reviews)

3.9

@devumair

Dear Client, I can help you with your task of pivot in SQL, I am a senior developer with rich experience. Lets talk to discuss your requirements. Regards.

$20 USD in 1 day

5.0

(2 reviews)

1.6

@aadityasharma912

I have 7 + years of experience into extensive sql development using multiple RDBMS suh as oracle, mysql, mssql postgre. I have a query for pivoting data which i hv written recently for my application purpose

$17 USD in 1 day