Variables in Stored Procedure

• tmwsiy

  Newbie

  Points: 2

  More actions

  October 28, 2005 at 10:39 am

  #102892

  I want to pass a list of part numbers to a stored procedure in the following format

  Select [stuff] from [tables] where part_no in (@partNumbers).

   

  Can this be done?  As a test I used:

  set @partNumbers = '''2000'',''653b'',''657'',''671'',''681'',''692'',''9617'''

  so that the @partNumbers is equal to '2000','653b','657','671','681','692','9617'

  but this does not work?

  I have user input in a db table in the form of 2000, 653b, 657, 671, 681,etc.

  My application and do any formating on the part number list supplied by the user but since I dont know the number of parts I'm kinda stuck.

  Any help would be great.

  thanks

  Christian

   

• Brenda-273346

  SSC Enthusiast

  Points: 198

  More actions

  October 28, 2005 at 10:56 am

  #601006

  Look at this article:

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 28, 2005 at 11:06 am

  #601010

  And this one.

  Arrays and Lists in SQL Server

• tmwsiy

  Newbie

  Points: 2

  More actions

  October 28, 2005 at 11:48 am

  #601028

  Many thanks to both of you

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 28, 2005 at 11:49 am

  #601029

  HTH.