I have a table:
CREATE TABLE [dbo].[usecase](
[id] [int] NULL,
[desc] [varchar](50) NULL,
[comm] [varchar](50) NULL,
[catgroup] [varchar](50) NULL
) ON [PRIMARY]
GO
Example data below:
insert into usecase (id, [desc], comm, catgroup) values(1,'desc 1', 'comment 1', '1')
insert into usecase (id, [desc], comm, catgroup) values(2,'desc 2', 'comment 2', '1,2')
insert into usecase (id, [desc], comm, catgroup) values(3,'desc 3', 'comment 3', '1,2,3')
insert into usecase (id, [desc], comm, catgroup) values(4,'desc 4', 'comment 4', '60,61')
insert into usecase (id, [desc], comm, catgroup) values(5,'desc 5', 'comment 5', '59,60,61')
insert into usecase (id, [desc], comm, catgroup) values(6,'desc 6', 'comment 6', '9,3')
The catgroup is the category id for each use case, it is a 1:n relationship - one use case could belong to more than one categories
In the above example data, category 1 has 3 use cases (1,2,3), category 2 has 2 use cases (2,3), category 3 has 2 use cases (3, 6) and so on.
What I am looking for is a query based on category id and return all the use cases that belong to this given category id.
The database is SQL Server 2014.