How to insert one to many valued parameters from a stored procedure into a table

Question

Viewing 3 posts - 1 through 2 (of 2 total)

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

Xedni SSCertifiable Points: 6951 More actions · Answer 1

Just something like this?

declare @RID int, @p1 int, @p2 int, @p3 int, @p4 int, @p5 int

declare @targetTable table

(

_key int,

_value int

)

insert into @targetTable (_key, _value)

values

(@rid,@p1),

(@rid,@p2),

(@rid,@p3),

(@rid,@p4),

(@rid,@p5)

Executive Junior Cowboy Developer, Esq.[/url]

gayesh Valued Member Points: 71 More actions · Answer 2

Valued Member

Points: 71

January 15, 2015 at 10:46 am

Thank you!

I will try it.

Rgds

Gayesh