<div>
Thanks, I also found a similar solution using the Select Pivot syntax on:<br />
<br />
<a href="http://stackoverflow.com/questions/1677645/using-pivot-in-sql-server-2008" rel="ugc">http://stackoverflow.com/questions/1677645/using-pivot-in-sql-server-2008</a>&nbsp;<br />
<br />
Jeroen
</div>


Thanks, I also found a similar solution using the Select Pivot syntax on:

http://stackoverflow.com/questions/1677645/using-pivot-in-sql-server-2008 [http://stackoverflow.com/questions/1677645/using-pivot-in-sql-server-2008] 

Jeroen

<div>
<div class="content wysiwyg-content">
I have a table in SQL 2008 with:<br />
<br />
Record &nbsp; Fieldname &nbsp; &nbsp; &nbsp; &nbsp;Fieldlabel &nbsp;FieldValue<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Name &nbsp; &nbsp; &nbsp; &nbsp;Jeroen<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Email &nbsp; &nbsp; &nbsp; &nbsp;Info@shareit.nu<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Active &nbsp; &nbsp; &nbsp; False<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Name &nbsp; &nbsp; &nbsp; Piet<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Email &nbsp; &nbsp; &nbsp; &nbsp;Info@Champagne.nl<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Active &nbsp; &nbsp; &nbsp; False<br />
<br />
I want to get an output like:<br />
<br />
Record &nbsp; &nbsp; Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Email &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Active<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jeroen &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Info@ShareIT.nu &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;False<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Piet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Info@Champagne.nl &nbsp; &nbsp; &nbsp; False<br />
<br />
Any suggestions how i can do this using SQL Commands?<br />
<br />
Thanks<br />
<br />
Jeroen
</div>
</div>


I have a table in SQL 2008 with:

Record   Fieldname        Fieldlabel  FieldValue
1                  1                 Name        Jeroen
1                  2                 Email        Info@shareit.nu
1                  3                 Active       False
2                  1                 Name       Piet
2                  2                 Email        Info@Champagne.nl
2                  3                 Active       False

I want to get an output like:

Record     Name             Email                             Active
1              Jeroen            Info@ShareIT.nu            False
2              Piet                Info@Champagne.nl       False

Any suggestions how i can do this using SQL Commands?

Thanks

Jeroen

Transpose SQL Table??

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.