The values (Val1Col, Val2Col) all come from parsing an XML received in the stored procedure.
>I'm assuming that the 'Val4Col
n' comes from the calling program? If this is the case, can you not build your lists in your calling program and pass them as parameters?
>
>If this is not the case, nevermind.
>
>>Hi,
>>
>>In a stored procedure I have a hard coded Insert expression:
>>
>>insert into mytable (col1, col2, col3) values (@Val4Col1, @Val4Col2, @Val4Col3)
>>
>>
>>Since the list of columns and values has to be built dynamically, I need to be able to create
>>this expression based on variables. E.g.
>>
>>declare @FieldNames as varchar(max)
>>set @FieldNames = 'col1, col2, col3'
>>
>>
>>
>>So, is it possible to create a variable for list of values and then combine it with the variable for the list of columns and
>>execute the INSERT? TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham