tmajor99

<div>
<div class="content wysiwyg-content">
I need a SQL Select that change the orientation of a table. &nbsp;Currently, I have a table containing two columns for each product. &nbsp;Each row represents a attribute value for the product. &nbsp;I need to list all the attributes horizontally as column not vertically as rows. &nbsp;<br />
<br />
Before: <br />
UPC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Attribute ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Attribute Value <br />
<br />
1234 &nbsp; &nbsp; &nbsp; &nbsp; Brand &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pillow <br />
1234 &nbsp; &nbsp; &nbsp; &nbsp; Sub-Brand &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MyPillow<br />
1234 &nbsp; &nbsp; &nbsp; &nbsp; Color &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; White <br />
1234 &nbsp; &nbsp; &nbsp; &nbsp; Fixture &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;N/A<br />
2188 &nbsp; &nbsp; &nbsp; &nbsp; Brand &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Kennmore <br />
3221 &nbsp; &nbsp; &nbsp; &nbsp; Color &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Black<br />
<br />
After: (this is the format I need this data in)<br />
UPC &nbsp; &nbsp; &nbsp; &nbsp;Brand &nbsp; &nbsp; &nbsp; &nbsp;Sub-Brand &nbsp; &nbsp;Color &nbsp; &nbsp; Fixture &nbsp; <br />
<br />
1234 &nbsp; &nbsp; &nbsp; &nbsp;Pillow &nbsp; &nbsp; &nbsp; &nbsp;MyPillow &nbsp; &nbsp; &nbsp;White &nbsp; &nbsp; N/A<br />
2188 &nbsp; &nbsp; &nbsp; &nbsp;Kennmore <br />
3221 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Black
</div>
</div>


I need a SQL Select that change the orientation of a table.  Currently, I have a table containing two columns for each product.  Each row represents a attribute value for the product.  I need to list all the attributes horizontally as column not vertically as rows.  

Before: 
UPC           Attribute ID           Attribute Value 

1234         Brand                     Pillow 
1234         Sub-Brand             MyPillow
1234         Color                       White 
1234         Fixture                    N/A
2188         Brand                     Kennmore 
3221         Color                      Black

After: (this is the format I need this data in)
UPC        Brand        Sub-Brand    Color     Fixture   

1234        Pillow        MyPillow      White     N/A
2188        Kennmore 
3221                                                 Black

SQL Selection to list attributes horizontally as columns

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.