I am trying to split a column within my table
This column contain 6 different types of committees each committee repeated more than 100 times now I want to make each committee in its own column such that each committee still see its ID.
- create a new table called dbo.committees
- add comitteeid column to request table
- create an update statement to update this new column committeeid by joining to new committe table
- make committeeid column not null
- create fk relationship from request table to new committee table