Passing List Of Values

• jagjitsingh

  Ten Centuries

  Points: 1059

  More actions

  August 13, 2016 at 12:57 am

  #329337

  Hi

  I have 2 tables Product , Attribute. In Attribute Table i have 3 fields . I am passing SpecsId as list of Values . If SpecsId parameter has 2 values 1,5 then it should return all those products which have both these values. In my case it should return ProductId 1 & 2.

  If i have database like this how it can be done

  1 1 1,5

  2 4 1

  3 2 1,5

  4 3 2,6

  Thanks

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  August 13, 2016 at 1:18 am

  #1895318

  DelimitedSplit8K maybe? Read the article, which is here[/url].

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  August 13, 2016 at 8:14 am

  #1895326

  pietlinden (8/13/2016)

  ---

  DelimitedSplit8K maybe? Read the article, which is here[/url].

  Definitely agree. jagjitsingh, pass your varchar parameter containing a delimited string, split it apart with DelimitedSplit8K and then use it for the query of your base table.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions