We are currently working with some data which is stored as in the screenshot below. We are using this to display information in a C# application. The only way we can get the application to work as needed is to have the information in one single row.
We have tried some methods on Display multiple rows and column values into a single row, multiple column values to no avail.
We require each row with the same date and
vehicleID to be on the same row to be output from our stored procedure.
Any help would be greatly appreciated. Cheers.