<div>
Yes, it is possible what you are looking for is called dynamic pivot functioanlity there are many examples out there in the web, I suggest you to look into one
</div>


Yes, it is possible what you are looking for is called dynamic pivot functioanlity there are many examples out there in the web, I suggest you to look into one

<div>
ashilo,<br />
<br />
I suspect the keyword here was &quot;dynamic&quot; &nbsp;:)
</div>


ashilo,

I suspect the keyword here was "dynamic"  :)

<div>
<div class="content wysiwyg-content">
When i run this query i get the following resultset<br />
<br />
SELECT distinct SubjectCode from &nbsp;IND13I.DBO.MSTMASSSTUDENTS<wbr /> <br />
WHERE Course='B.Arch' and semester=1 order by 1<br />
<br />
Resultset<br />
SubjectCode<br />
AR101<br />
AR102<br />
AR103<br />
AR104<br />
AR105<br />
AR106<br />
AR107<br />
<br />
How to display this in horizontal or as columns &nbsp;or how to transpose it so that i can create the table as<br />
create table x (AR101 VARCHAR(200),AR102 VARCHAR(200) and so on<br />
<br />
Is it possible.
</div>
</div>


When i run this query i get the following resultset

SELECT distinct SubjectCode from  IND13I.DBO.MSTMASSSTUDENTS 
WHERE Course='B.Arch' and semester=1 order by 1

Resultset
SubjectCode
AR101
AR102
AR103
AR104
AR105
AR106
AR107

How to display this in horizontal or as columns  or how to transpose it so that i can create the table as
create table x (AR101 VARCHAR(200),AR102 VARCHAR(200) and so on

Is it possible.

How to create a temporary table from resultset.

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.