Using A recordset as an input parameter for a stored procedure

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 2, 2005 at 8:04 am

  #587208

  What page??

  The link (Help us help you) I provide is not from me!!!

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  September 2, 2005 at 8:17 am

  #587222

  I'll be switched - I thought you did that.  Sorry for the confusion.

  I wasn't born stupid - I had to study.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 2, 2005 at 8:21 am

  #587225

  I know that the inserts generator is made by vyaskn, but I don't know if he's the author of the primary link. Sorry to burst your bubble.

• Darren Beale

  SSC Enthusiast

  Points: 171

  More actions

  September 5, 2005 at 4:17 am

  #587541

  In my opinion the best solution to this problem by far is to pass an XML document from your VB client to the SP on the server: for example:

  Then use the OpenXML keyword in your SP - you can read it as if it was a table.

  This mechanism also fits in really well with VB OOP, becuase you can get each class instance to save itself as XML, concatinate them and thow them at a single SP.