<div>
<div class="content wysiwyg-content">
i have a table in below mentioned format: 
 
StateID &nbsp; ColorID &nbsp; &nbsp; ColorDesc 
21 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Green 
21 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red 
21 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A 
22 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Green 
22 &nbsp; &nbsp; &nbsp; &nbsp; 19 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B 
23 &nbsp; &nbsp; &nbsp; &nbsp;55 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M 
27 &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp; Cofee 
27 &nbsp; &nbsp; &nbsp; 99 &nbsp; &nbsp; &nbsp; &nbsp;Blue 
etc.. 
 
 
I want to stored procedure in MS Sql Server 2005 &nbsp;which should return the output in below format: 
sateid &nbsp; RequiredColorDetails 
21 &nbsp; &nbsp; &nbsp; &nbsp; 5|Green|18|Red|11|A 
22 &nbsp; &nbsp; &nbsp; 5|Green|19|B 
23 &nbsp; &nbsp; &nbsp;55|M 
27 &nbsp; &nbsp; &nbsp;100|Cofee|99|Blue 
etc.. 
 
Please help me. 

</div>
</div>

i have a table in below mentioned format:

StateID   ColorID     ColorDesc
21           5             Green
21           18           Red
21            11          A
22           5          Green
22         19          B
23        55          M
27       100       Cofee
27       99        Blue
etc..


I want to stored procedure in MS Sql Server 2005  which should return the output in below format:
sateid   RequiredColorDetails
21         5|Green|18|Red|11|A
22       5|Green|19|B
23      55|M
27      100|Cofee|99|Blue
etc..

Please help me.


Stored procedure to retreive data in MS Sql Server

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.