<div>
SQL wont support that in any way that is even moderately efficient. Can you process the data outside of SQL?
</div>


SQL wont support that in any way that is even moderately efficient. Can you process the data outside of SQL?

<div>
I wonder also about such a requirement, and can confirm that with &quot;sql&quot;, you cannot do this.<br />
<br />
in ms excel, it would be a &quot;transpose&quot; function ...
</div>


I wonder also about such a requirement, and can confirm that with "sql", you cannot do this.

in ms excel, it would be a "transpose" function ...

<div>
<div class="content wysiwyg-content">
Hello Experts ,<br />
<br />
I have a table test , which has values as like below:<br />
<br />

<pre><code id="code-10-27847447-1">select * from test;

col1 col2 
1	AA
2	BB</code></pre>
<br />
Now I want &nbsp;to get the result as below on SQL Server 2008 version without using pivot: <br />
<br />

<pre><code id="code-10-27847447-2">column_name  data1 data2        
col1 1  2
col2 AA BB</code></pre>
</div>
</div>


Hello Experts ,

I have a table test , which has values as like below:

(CODE)

Now I want  to get the result as below on SQL Server 2008 version without using pivot: 

(CODE)

SQL query

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.