<div>
here's a nice explanation of how to achieve this, using CASE:<br />
<br />
Creating cross tab queries and pivot tables in SQL<br />
<a href="http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/" rel="ugc">http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/</a>
</div>


here's a nice explanation of how to achieve this, using CASE:

Creating cross tab queries and pivot tables in SQL
http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/ [http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/]

<div>
Appears easy. &nbsp;I'll give it a try. &nbsp;Thanks for your quick response. <br />
<br />
Regards,<br />
Alan
</div>


Appears easy.  I'll give it a try.  Thanks for your quick response.

Regards,
Alan

<div>
<div class="content wysiwyg-content">
Hello. &nbsp;I am trying to develop an ASP.NET app that displays linear data as a pivot table, and I have no idea how to go about it. My table is set up like this:<br />
VESSEL<br />
VOYAGE<br />
PORT<br />
ARRIVAL<br />
I want this to display in a table like the following:<br />
VESSEL &nbsp; VOYAGE &nbsp; PORT1 &nbsp; PORT2 &nbsp; PORT3 &nbsp; (Ports are different)<br />
vsl1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;voy1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date1 &nbsp; &nbsp; &nbsp;date2 &nbsp; &nbsp;date3<br />
vsl2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;voy2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date1 &nbsp; &nbsp; &nbsp;date2 &nbsp; &nbsp;date3<br />
vsl3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;voy3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date1 &nbsp; &nbsp; &nbsp;date2 &nbsp; &nbsp;date3<br />
<br />
Can somebody help me with this? In Access, this is pretty easy, but how do I do this in SQL Server 2000? 
</div>
</div>


Hello.  I am trying to develop an ASP.NET app that displays linear data as a pivot table, and I have no idea how to go about it. My table is set up like this:
VESSEL
VOYAGE
PORT
ARRIVAL
I want this to display in a table like the following:
VESSEL   VOYAGE   PORT1   PORT2   PORT3   (Ports are different)
vsl1          voy1          date1      date2    date3
vsl2          voy2          date1      date2    date3
vsl3          voy3          date1      date2    date3

Can somebody help me with this? In Access, this is pretty easy, but how do I do this in SQL Server 2000? 

PIVOT TABLE - SQL Server 2000

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.