Hi,
I have a stored proc that runs and return data for a data table.
The columns should be Date;Name; then each following column is time . So it looks something like this.
Date;Name;00:00; 00:15; 00:30; 00:45;01:00… this continues till 24:00.
How can i get the data table to automatically generate the columns in the correct order.
The reason for this is because the result being returned is a sql pivot result.
Hope you can help