Find Jobs
Hire Freelancers

Need a simple PIVOT query for some SQL data

$10-30 USD

Opravljeno
Objavljeno pred skoraj 5 leti

$10-30 USD

Plačilo ob dostavi
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.
ID projekta: 19982455

Več o projektu

4 ponudb
Projekt na daljavo
Aktivno pred 5 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
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 v 0 dnevu
5,0 (237 ocen)
7,6
7,6
4 freelancerjev je oddalo ponudbo s povprečno vrednostjo $18 USD za to delo
Avatar uporabnika
Hello sir I'm professional sql developer having 5 years of experience please contact me........ ....
$15 USD v 1 dnevu
5,0 (12 ocen)
3,9
3,9
Avatar uporabnika
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 v 1 dnevu
5,0 (2 ocen)
1,6
1,6
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
San Diego, United States
5,0
84
Plačilna metoda je verificirana
Član(ica) od nov. 30, 2008

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.