IN condition is not working in Stored procedure

• prabhakaran.ece

  SSC Rookie

  Points: 34

  More actions

  November 5, 2008 at 12:36 am

  #193239

  Hi,

  I am passing comma seperated values to SP where i am using IN in the where condition, but its not displaying query results.

  Please give me a solution

  Thanks,

  Prabha

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  November 5, 2008 at 3:28 am

  #894108

  prabhakaran.ece (11/5/2008)

  ---

  Hi,

  I am passing comma seperated values to SP where i am using IN in the where condition, but its not displaying query results.

  Please give me a solution

  Thanks,

  Prabha

  Use dynamic queries or let me know the query you are using

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com

• j nuñez

  SSCrazy

  Points: 2175

  More actions

  November 5, 2008 at 3:43 am

  #894118

  Instead of using dynamic SQL, you can transform the list of values ( 'a, b, c, ... ') into a Table, and then make a JOIN.

  Something like this:

  select f1, f2, f3,

  from YourTable,

  fn_Transform(@paramListOfValues) as Values

  WHERE YourTable.field = Values.field

  There are a lot of articles about this idea in this website and in the www.

  For example:

  http://www.sqlservercentral.com/articles/T-SQL/63003/

  You can make searchs with these words:

  'Array in SQL'

  'Tally Table'