It's been awhile, but can you not concatenate the values into a variable as you parse the XML?
>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.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place