Posting Yak Master
Posted - 03/14/2013 : 08:48:52
| i want to execute a stored proc and insert all its values in a table. And i also want to insert an additional
value with columns that are inserted bt sp.
like my proc is :
create procedure test_proc
select 1 as num
select 2 as num
and my table is :
create table test_ins
(pid numeric(10) , num numeric(10) )
and when i run i want to insert @pid value in the table along with sp values.
declare @pid numeric(10) = 999
insert into test_ins(pid , num )