<div>
can you share sample format of your table.
</div>


can you share sample format of your table.

<div>
Works great. &nbsp;Thank you so much.
</div>


<div>
no problem, which one did you use? (with dates?)
</div>


no problem, which one did you use? (with dates?)

<div>
<div class="content wysiwyg-content">
I have a table ItemNotes (ItemID int, Note varchar(255),NoteDate datetime) in a MS SQL Server2005 database. &nbsp;I need to have all of the note and notedate fields for an itemID combined into the same row. &nbsp;It is unknown how many Notes a given item has. &nbsp;I have been attempting a cursor or pivot but I cannot seem to get it working. &nbsp;Any assistance is appreciated.
</div>
</div>


I have a table ItemNotes (ItemID int, Note varchar(255),NoteDate datetime) in a MS SQL Server2005 database.  I need to have all of the note and notedate fields for an itemID combined into the same row.  It is unknown how many Notes a given item has.  I have been attempting a cursor or pivot but I cannot seem to get it working.  Any assistance is appreciated.

MS SQL Columns To Rows

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.