Table as Stored Procedure parameter

• Miquel Martí

  Ten Centuries

  Points: 1217

  More actions

  February 10, 2006 at 3:27 am

  #111388

  Hi!

  I need to pass a TABLE as a parameter to a stored procedure

  I'm sure this has been asked more than once, and I'v read in BOL that TABLE types are not supported as parameters.

  How do you deal with this actually?

  I need to pass an array of values to a SP

   

  tkx

   

• Jesper-244176

  SSCertifiable

  Points: 7142

  More actions

  February 10, 2006 at 5:04 am

  #620070

  Have a look at

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=255935#bm255940

• Miquel Martí

  Ten Centuries

  Points: 1217

  More actions

  February 10, 2006 at 6:56 am

  #620093

  Thanks Jesper!

  That solution is what I already did to turn arround the problem.

  I'm used to PL-sql, and try to do same things in TSQL.

  Hope Transac evolves for better.

   

  tks again