<div>
select empid, Year = '2008', 2008Scores as ScoreValue<br />
where empid = 2<br />
union<br />
select empid, Year = '2009', 2009Scores as ScoreValue<br />
where empid = 2<br />
union<br />
select empid, Year = '2010', 2010Scores as ScoreValue<br />
where empid = 2
</div>


select empid, Year = '2008', 2008Scores as ScoreValue
where empid = 2
union
select empid, Year = '2009', 2009Scores as ScoreValue
where empid = 2
union
select empid, Year = '2010', 2010Scores as ScoreValue
where empid = 2

<div>
<div class="content wysiwyg-content">
Hi,<br />
i have a following table. I want to display some column as rows. Please help me achieving this.<br />
Here is the sample table<br />
EmployeeTable<br />
---------------<br />
EmpID &nbsp;2008Scores 2009Scores &nbsp; 2010Scores<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18<br />
<br />
I want the result like this<br />
<br />
EmpID &nbsp;Year &nbsp; &nbsp;ScoreValue<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2008 &nbsp; &nbsp; 12<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2009 &nbsp; &nbsp; &nbsp;14<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2010 &nbsp; &nbsp; &nbsp;18<br />
<br />
Please help.<br />
<br />
Thanks.
</div>
</div>


Hi,
i have a following table. I want to display some column as rows. Please help me achieving this.
Here is the sample table
EmployeeTable
---------------
EmpID  2008Scores 2009Scores   2010Scores
2             12               14                18

I want the result like this

EmpID  Year    ScoreValue
2           2008     12
2          2009      14
2          2010      18

Please help.

Thanks.

Sql server 2008 query help

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.