? T-SQL dynamic pivot

Ok I have a table that looks like thisItemID | ColumnName | Value1 | name | Peter1 | phone | 123456781 | email | peter@host.com2 | name | John2 | phone
 ? T-SQL dynamic pivot

Ok I have a table that looks like thisItemID | ColumnName | Value1 | name | Peter1 | phone | 123456781 | email | peter@host.com2 | name | John2 | phone
 ? T-SQL dynamic pivot

Ok I have a table that looks like thisItemID | ColumnName | Value1 | name | Peter1 | phone | 123456781 | email | peter@host.com2 | name | John2 | phone
 ? Converting Row to Column dynamically in SQL

This question already has an answer here: T-SQL dynamic pivot 5 answers You need to create the SQL Dynamically
 ? I'm currently looking for a dynamic way to convert rows to columns in a specific way in SQL server

This question already has an answer here: T-SQL dynamic pivot 5 answers This is also known as a dynamic pivot -
 ? Microsoft SQL Server: Adding New Column To Row Instead Of Repeated Values

Here's my current situation:I'm presented with a long list of data, containing names and values, with a corresponding value ID. The number of IDs can be varying for data presented, but is constant for
 ? Joining tables and LEFT JOIN as new Columns in tsql

In this sample I have two tables containing data for my Customer and Products that a office supply shop has. which is seen below: The Above tables primarily functions to supply the required data for
 ? Convert row to columns SQL dynamically

This question already has an answer here: Simple way to transpose columns and rows in Sql? 6 answers
 ? query to combine multiple columns in one columns

I have table which contain the following information. I want to run a query and show only one line. something like thisI try to use a case statement, However i maybe have other employee who work in di
 ? Converting stored events into single records

I am currently working on a project that needs to utilize data stored in a SQL db in the format shown below.What I need to do, and am having difficulty finding a tool to help with, is to take this dat
 ? Pivot table multiple column values in a single column

I've got a table like that, id PID VID Type PriceA PriceB41 297 2 128 70.000 80.000 42 297 3 256 90.000 100.000 43 297 4 30
 ? SQL Server - Dynamic Pivot

I'm needing some help. I have two columns, Place and Name, I want a count of Name for each place. Currently the data would look like:Place | Name100 OK100 NEW100 BAD 200 BAD200 BA
 ? SQL Server - Dynamic Pivot

I'm needing some help. I have two columns, Place and Name, I want a count of Name for each place. Currently the data would look like:Place | Name100 OK100 NEW100 BAD 200 BAD200 BA
 ? SQL Server - Dynamic Pivot

I'm needing some help. I have two columns, Place and Name, I want a count of Name for each place. Currently the data would look like:Place | Name100 OK100 NEW100 BAD 200 BAD200 BA
 ? Transform existing SQL into a pivot by column

This question already has an answer here: SQL Server - Dynamic Pivot 1 answer Got it working (thanks igloo for
 ? SQL Server Dynamic Pivot

Hello I have a table that contains employee punch in and punch out data from a timekeeping system. I am looking to dynamically pivot the punch data column and total an employees shift span. However I

Page 2 of 2662  |  Show More Pages:  Top Prev Next Last