stored procedure prob

• esqared7

  SSC Veteran

  Points: 241

  More actions

  November 11, 2003 at 5:39 am

  #162684

  How do I accept an array as a input parameter in a sql stored procedure. Basically what I am trying to do is that I have a sql query in a stored procedure as

  select * from P_Trade where TypeId IN(@Typeid)

  TypeId is a integer type column in the database and from the code I am passing @Typeid as varchar(100) as its value can be

  Request.form("Type") which returns 100,101,102

  but when I execute the query in sql it gives a error like Typeid cannot be converted to varchar from int

  The other way I think would be to use an array and pass it to the stored procedure but then how do I retrieve the value of this dynamic array in the stored procedure

  Thanks.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 11, 2003 at 5:44 am

  #481564

  I suggest this onr for reading http://www.algonet.se/~sommar/arrays-in-sql.html

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• David Burrows

  SSC Guru

  Points: 65138

  More actions

  November 11, 2003 at 6:17 am

  #481566

  select * 
  
  from P_Trade 
  
  where charindex(','+cast(TypeId as varchar)+',',','+@Typeid+',') > 0 
  
   

  Far away is close at hand in the images of elsewhere.
  Anon.