I am facing a problem with MS-SQL in getting output from a table in a particular format.
Name | StringValue | Parent_ID FieldName | TestHeader1 | 3 FieldValue | ValueForTestHeader1 | 3 FieldName | TestHeader2 | 6 FieldValue | ValueForTestHeader2 | 6
And I want to select data from this table as follows:
TestHeader1 | TestHeader2 ValueForTestHeader1 | ValueForTestHeader2
Any help would be highly appreciated!</div