|
pnpsql
Posting Yak Master
India
241 Posts |
 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
as
select 1 as num
union
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 )
exec test_proc
kindly help
challenge everything |
|
insert values from sp help
