выборка с некоторой логикой - SQL Server - Ответ 4317170

declare @Specifications varchar(max)='21,26,29'
set @Specifications='21,23,29'
-- if object_id('tempdb..#tb_SpecificationAnswers') is not null drop table #tb_SpecificationAnswers
if object_id('tempdb..#tb_SpecificationAnswers') is null begin
    create table #tb_SpecificationAnswers (SpecificationID int,AnswerID int)
    insert #tb_SpecificationAnswers values 
       (2,20),(2,21),(3,15),(3,16),(3,17),(3,18),(3,19),(3,30),(3,31),(3,32),(4,22),
      (4,23),(4,24),(4,25),(4,26),(5,27),(5,28),(5,29)
end
-- if object_id('tempdb..#tb_GoodsSpecificationAnswers') is not null drop table #tb_GoodsSpecificationAnswers
if object_id('tempdb..#tb_GoodsSpecificationAnswers') is null begin
    create table #tb_GoodsSpecificationAnswers (GoodsID int, SAID int)
    insert #tb_GoodsSpecificationAnswers values 
       (1,21),(1,22),(1,26),(1,29),(1,31),(2,17),(2,21),(2,22),(2,25),(2,26),(2,29),
       (4,18),(4,21),(4,23),(4,26),(4,29),(5,21),(5,22),(5,23),(5,26),(5,29),(5,30),(6,19),(6,21),(6,23),(6,26),(6,27),
       (7,21),(7,22),(7,23),(7,24),(7,25),(7,26),(7,29),(7,32)
end