SQL Server pivots? some way to set column names to values within a row
- by ccsimpson3
I am building a system of multiple trackers that are going to use a lot of the same columns so there is a table for the trackers, the tracker columns, then a cross reference for which columns go with which tracker, when a user inserts a tracker row the different column values are stored in multiple rows that share the same record id and store both the value and the name of the particular column.
I need to find a way to dynamically change the column name of the value to be the column name that is stored in the same row.
i.e.
id | value | name
------------------
23 | red | color
23 | fast | speed
needs to look like this.
id | color | speed
------------------
23 | red | fast
Any help is greatly appreciated, thank you.
