Using A recordset as an input parameter for a stored procedure

• Andrew Daniels

  Old Hand

  Points: 395

  More actions

  August 31, 2005 at 5:42 am

  #165370

  I have created a stored procedure that takes one input parameter. I am trying to pass a recordset, which contains over 300 values, as the input parameter. Therefore saving me executing the Sproc 300 times.

  I have tried using a global variable within a DTS package to populate the sproc, but keep getting the error EXECTION_ACCESS_VIOLATION.

  Can anyone help?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 31, 2005 at 6:30 am

  #586425

  Please do not cross-post we monitor all boards.

  Check my follow-up question here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=215614