Pivot table with dynamic columns

[Aram Mirzadeh]

Hi,

I have a dynamic requirement. I am trying to build a view (via SPROC) that would generate a list of vendor_fk as the left column and each product as a column after that. The cells of the pivot would be the latest date on which there is an try for that product/vendor combination entry.

I have setup a sqlfiddle with the relevant schema/sample data. I can also share my SPROC but the query middle part is in the fiddle as well -- iteration #2. Iteration #1 only listed 1 product per vendor row no matter how many entries there were.

Fiddle Schema: http://sqlfiddle.com/#!9/92bc9/7

Any help would be greatly appreciated.