I have a KVP Key value pair Table, Need sql to make it relational structure...!

Posted by Muthuveerappan on Stack Overflow See other posts from Stack Overflow or by Muthuveerappan
Published on 2010-03-20T10:33:29Z Indexed on 2010/03/20 10:41 UTC
Read the original article Hit count: 210

Filed under:

sql

|

relational

|

key

|

value

|

pair

I have a KVP Table and the structure is ID, Key, Value and below are the sample values....

Table with values

ID , Key, Value
1 , STATUS, TRUE
1, AGE GROUP, 10
1, TRAVEL, Y
2 , STATUS, FALSE
2, AGE GROUP, 20
2, TRAVEL, N

I want these date to transform as below (Output)

ID , STATUS, AGE GROUP, TRAVEL
1, TRUE , 10, Y
2, FALSE, 20, N

I have read about crosstab/pivot - but not able to make a query which can give me the above output. The table structure cant be changed...! My bad.

Is there any way in sql, to make my output look like above ?

© Stack Overflow or respective owner

Related posts about sql

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More

Related posts about relational

Help to translate SQL query to Relational Algebra

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I'm having some difficulties with translating some queries to Relational Algebra. I've a great book about Database Design and here is a chapter about Relational Algebra but I still seem to have some trouble creating the right one: Thoes queries I've most difficuelt with is these: SELECT… >>> More
What relational database innovations have there been in the last 10 years

as seen on Stack Overflow - Search for 'Stack Overflow'
The SQL implementation of relational databases has been around in their current form for something like 25 years (since System R and Ingres). Even the main (loosely adhered to) standard is ANSI-92 (although there were later updates) is a good 15 years old. What innovations can you think of with… >>> More
Big Data – Buzz Words: Importance of Relational Database in Big Data World – Day 9 of 21

as seen on SQL Authority - Search for 'SQL Authority'
In yesterday’s blog post we learned what is HDFS. In this article we will take a quick look at the importance of the Relational Database in Big Data world. A Big Question? Here are a few questions I often received since the beginning of the Big Data Series - Does the relational database have… >>> More
Relational Database pioneer Chris Date is giving a seminar 13th/14th May Edinburgh on "SQL and Relat

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
One of the pioneers of the Relational Database, Chris Date is giving a 2 day seminar in Edinburgh (13th and 14th May 2010) based around his new book "SQL and Relational Theory - How to Write Accurate SQL Code" which if you don't already have I'd say is a must buy. When I first saw… >>> More
Chris Date on "SQL and Relational Theory - How to Write Accurate SQL Code"

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
The importance of relational theory......(read more) >>> More