Passing an array to a SP

• Daniela-267581

  Ten Centuries

  Points: 1119

  More actions

  April 6, 2006 at 5:19 am

  #112793

  Hi,

  I am trying to pass an array as a parameter to a SP. Meaning: I have some ids, let's say 3,4,5 and I want inside the SP to look for them and populate a temporary table.Finally, I want to retrieve the data from the temporary table with a simple select.

  How can I pass an array to the SP?

  Thanks a lot

  ---

  Daniela

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  April 6, 2006 at 5:39 am

  #631176

  This is the best article on this topic (from a SQL Server MVP):

  http://www.sommarskog.se/arrays-in-sql.html

   

• Daniela-267581

  Ten Centuries

  Points: 1119

  More actions

  April 6, 2006 at 5:50 am

  #631179

  Thank you! Very good material!

  ---

  Daniela