In this article, I will explain How to create a
Dynamic Pivot Without Aggregation Function in SQL Server
I have the below three tables (One-Many relations)
- The 1st table (Table) holds tables name.
- The 2nd table (Fields) is related to (Table) to hold the fields name for each table.
- The 3rd table (Field Value) is related to (Fields) to hold fields value for each field.
I would like to show all related data (Fields and its value) for each table name (Entity) in the 1st table to be structured as a real independent table.