SQL Query by pivoting results
Budget: €8 – €30 EUR
I am looking for a freelancer who can help me with a SQL query to summarize data and pivot results by IDs. The specific columns that need to be included in the pivot table are Date, ID, and Value. I am using SQL Server as my database management system.
Ideal Skills and Experience:
- Strong knowledge and experience in SQL
- Proficiency in SQL Server
- Ability to summarize data and pivot results
- Familiarity with Date, ID, and Value columns in SQL queries
An example of what I am trying to achieve is in the excel sheet attached. The red box in tab "SQL Output" is the output that I am trying to achieve with Trade Dates running down, and IDs running across
Ideal Skills and Experience:
- Strong knowledge and experience in SQL
- Proficiency in SQL Server
- Ability to summarize data and pivot results
- Familiarity with Date, ID, and Value columns in SQL queries
An example of what I am trying to achieve is in the excel sheet attached. The red box in tab "SQL Output" is the output that I am trying to achieve with Trade Dates running down, and IDs running across