Top "Pivot-without-aggregate" questions

TSQL Pivot without aggregate function

I have a table like this... CustomerID DBColumnName Data -------------------------------------- 1 FirstName Joe 1 MiddleName S 1 LastName Smith 1 Date 12/12/2009 2 FirstName Sam 2 MiddleName …

sql sql-server tsql pivot pivot-without-aggregate

SQL Transpose Rows as Columns

I have an interesting conundrum which I believe can be solved in purely SQL. I have tables similar to the …

sql postgresql pivot pivot-without-aggregate

how to transform vertical fields in a table to horizontal result by SQL

I have a table like this: create table t1 { person_id int, item_name varchar(30), item_value varchar(100) }; Suppose person_…

sql transform pivot pivot-without-aggregate

sql query to show results vertically

How to transform this: ID Name Description 1 Test1a TestDesc1a 1 Test1b TestDesc1b 2 Test2a TestDesc2a 2 Test2…

sql sql-server-2008-r2 pivot pivot-without-aggregate

Sql Server 2008 - PIVOT without Aggregation Function

I know you've got multiple topics touching on this. But, I havent found one that addressed my needs. I need …

sql sql-server-2008 pivot pivot-without-aggregate