MS SQL T-SQL: Rows to Columns

Completed Posted 4 months ago Paid on delivery
Completed Paid on delivery

I've uploaded some basic data. It has 2 columns. Column 1 is a Publication Index and column 2 is an authors name. I need a T-SQL query that will create a pivot table that will put the authors names into columns and the PMID's into rows. The xls sheet has the data and the output that I need. I'm posting the question here because I need a faster answer than posting on StackOverFlow. The data will have over 8,000 rows of data and the columns or names will be over 100.

My current T-SQL is

SELECT TOP (100) PERCENT PMID, AuthoringName

FROM dbo.[[login to view URL]]

GROUP BY PMID, AuthoringName

ORDER BY PMID, AuthoringName

I'm using MS SQL 2019

SQL Microsoft SQL Server Database Programming Database Administration

Project ID: #37642960

About the project

19 proposals Remote project Active 4 mos ago

Awarded to:

abdulqadir4613

As a full stack developer and experienced data analyst, I am skilled at utilizing complex SQL queries to manipulate data and deliver tailored insights. Your project of transforming rows into columns with over 8,000 row More

$30 USD in 1 day
(2 Reviews)
1.2

19 freelancers are bidding on average $25 for this job

mobimubasir

Hello. I read your requirement and also check attachments on i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

$20 USD in 1 day
(17 Reviews)
4.8
aleksisgsr

Hello, I'm a SQL server developer with more than 10 years of experience. Over 7 years I worked as senior SQL Server developer in various companies. I design databases, schemas, indexes, constraints, develop complex More

$30 USD in 1 day
(4 Reviews)
3.5
MirhaKhan786

As an experienced database developer and SQL specialist, I am your go-to expert for transforming your dataset in the most efficient manner. The task at hand requires translating numerous rows to columns while ensuring More

$20 USD in 1 day
(1 Review)
3.0
wilfrednjorog

Hey William M.! Your MS SQL T-SQL: Rows to Columns is exactly the type of project that sparks my interest and motivates me to get involved. With years of experience in Database Programming, SQL, Microsoft SQL Server More

$25 USD in 1 day
(0 Reviews)
0.0
jinufeb14

As luck would have it, MS SQL and pivoting data is a specialty of mine! I've used the platform extensively, including its latest 2019 version like you need, to craft efficient and scalable solutions. For instance, in q More

$20 USD in 7 days
(0 Reviews)
0.0
CodeFrenzyCo

Hi , We hope this message finds you well. We have a team of experienced MS SQL Server developers with a background since 2018 in the field. We have carefully reviewed the initial project description you provided and we More

$25 USD in 3 days
(0 Reviews)
0.0
NaaharTech

Helloo sir Certainly, I can help you with that. To pivot the data in T-SQL, we can use the PIVOT operator. The query will dynamically generates the column names for the authors and then uses the PIVOT operator to tran More

$50 USD in 1 day
(0 Reviews)
0.0
MaiNga9660

Hi Dear! I have checked the project on your work " MS SQL T-SQL: Rows to Columns ". I have a lot of experiences in fields of ⭐ SQL, MySQL for Database management ⭐, also read the project description carefully and can s More

$20 USD in 1 day
(0 Reviews)
0.0
ms7620281

Hello, Greetings! I hope you are doing great. I am writing to express my enthusiasm for the opportunity to collaborate on this project. With over 12 years of dedicated experience in the field, I bring a wealth of exper More

$20 USD in 7 days
(0 Reviews)
0.0
belistojanov

Hello, I am confident in delivering the T-SQL solution you require for transforming your data into a pivot table efficiently. Leveraging my expertise in MS SQL 2019, I propose to enhance your existing query to dynamic More

$20 USD in 7 days
(0 Reviews)
0.0
idogoldblatt

With my range of skills honed over four years in software development, I am well-equipped to help you tackle your project title: MS SQL T-SQL: Rows to Columns. I have extensive knowledge and hands-on experience with SQ More

$25 USD in 2 days
(0 Reviews)
0.0
Alizakhani32

Hello, I hope this proposal finds you well. I have carefully reviewed your project requirements, and I am confident that I can assist you in creating the desired pivot table using T-SQL. To accomplish this task, I wi More

$30 USD in 1 day
(0 Reviews)
0.0
samuelmolling

Hello, my name is Samuel and I am a specialist in DBMSs. I have great expertise in SQL Server and can easily help you solve your SQL problem. Let me know what you think and if you have any questions, you can get in tou More

$30 USD in 1 day
(0 Reviews)
0.0
regonb

gone through your data and already transform your data . With over a decade of specialized experience in MS SQL and a deep understanding of database design principles, I am confident in my ability to solve complex dat More

$20 USD in 7 days
(0 Reviews)
0.0