MS SQL Columns To Rows
Posted on 2013-05-24
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.