I have a ticket details table with n number of columns.Each project has a specific configuration to select a specific number of columns to find the repeat count of same column values.
Existing i have a table with fixed column names with the values saved and frequency maintained for all projects.
Now,i need to achieve the same value storage with count with varied columns for each project
For eg:If project 1 chooses column1, column2, column3 then resultant table should have these 3 column values and count of tickets
Similarly the next project can choose column1,column3 and if so then for this project values should be tracked for these 2 and count.
Need to achieve this logic in a single sql server table dynamically