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