Stored proc: Insert Into

[MarkGreen]

Hi,
I need to copy some selected data from one table to another using a stored proc. This isnt a problem - i figured i should be using insert into. However the problem is, the table that I am inserting into needs to obtain one of its column values from a local variable and not from the select statement.

What is the syntax for doing this?

Thanks,
Mark.

 

[sunila7]

hi,

Try this....


declare @l varchar(20)
set @l ='25'
insert into yourtable(field1,field2,LocalvariableField)
select field1,field2,@l from charge



Hope it helps....

Sunil

 

[MarkGreen]

thats excellant, thanks
Mark