I've tried the Pivot table and it doesn't seem to be working... can you comment on the following query?

Select BidId,

'Cancelled',

'In Progress',

'Loss',

'New',

'No Bid',

'Referred Out'

FROM (

Select bi.BidId, dbo.Status.Name, dbo.StatusComments.CommentDate

From Bids...

I am interested as to how or if we can pull a cross-tab or pivot dynamically. I have a query that can have an undetermined amount of comments associated to...