I have a stored procedure. For design reasons, I can't alter much of the SQL itself. However, if you look at the attached image of the recordset I'll explain what I have and what I need. The SQL itself builds up a table. The data is based on bids from multiple vendors. So, the customer raises a requisition and gets vendors to bid on it. The requisition contains items. Each vendor sends in their price and the winning vendor gets awarded the bid.
As the stored procedure runs, this table gets built up. You can see the structure. The record ID is an identity column. The date stamp was added for debugging purposes but isn't important in the output. The first line from nvchColumn1 onwards will always be:
Where Vendor is the vendors name. After that the items from the requisition are added for each vendor. So in this example, there are 2 vendors for 1 requisition containing 3 items. Rows 2, 3, and 4 show the items for vendor 1 and their prices; rows 5, 6, and 7 show the items for vendor 2.
What I need to get out somehow, is a table that shows the columns:
but only 4 rows. So, what I'm looking for is this output below:
The first line contains Item Details in the first column, then each of the sccuessive columns has the Vendor name in it. The rows below give the figures.