I have a database called 'Customer' within it I have a table called 'Product' and within this product table I have a column called 'Class' and ' Client'. Now this class column has single values and numerous values in the column separated by a ; it looks like this:
what i am trying to accomplish is separate all of the classes by client and apply a text value to the class. for example here is the text value I want to correspond with the numerical values under the class column. (unfortunately these text values are not in the database and I dont have permission to create a table).
This is what the desired output would look like.
How would I do this? I am using Microsoft SQL Server Management Studio