0

I have simple two fields query which is as below.

SELECT FieldName, FieldData FROM EmpVchrTable
FieldName FieldData
Date From 25/01/2021
Date To 31/01/2021
Vehicle Name Hyundai Azera
Vehicle Register No. 234
Mileage 43
Amount 2222
Notes test

And I want result like this

Date From Date To Vehicle Name Vehicle Register No. Mileage Amount Notes
25/01/2021 31/01/2021 Hyundai Azera 234 43 2222
Zakaria
  • 4,643
  • 2
  • 4
  • 29
Raja
  • 99
  • 2
  • 15
  • This works for one row. I dont want to aggregate and I do not know the column names either because column names are dynamically created in DB – Raja Dec 28 '21 at 05:56

0 Answers0