MS SQL T-SQL: Rows to Columns
$10-30 USD
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
Project ID: #37642960
About the project
Awarded to:
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
19 freelancers are bidding on average $25 for this job
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.
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
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
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
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
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
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
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
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
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
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