Using A recordset as an input parameter for a stored procedure

Question

Post reply

Using A recordset as an input parameter for a stored procedure

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

What page??

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

Farrell Keough SSCoach Points: 17414 More actions · Answer 2

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 · Answer 3

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 · Answer 4

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.