>>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'
>>-- and I can't even figure how to concatinate the list of values into a variable
>>

>>
>>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?
>
>Not my subject but maybe buildup the string. Something like:
> Declare @SQLQuery AS NVarchar(4000)
>Set @SQLQuery = 'INSERT INTO mytable('+@FieldNames+') VALUES (@Val4Col1,@Val4Col2,@Val4Col3)
>EXECUTE(@SQLQuery)

This is pretty much the approach I am trying to implement. Except I am using SP_EXECUTESQL (which according to one on-line article is supposed to be more efficient). Thank you.