Hi Experts,
I have write a sp which returns table of records (exec spname @param1).
I have to store the records in temptables with some constants values
eg
create table #temp(studif int, studname varchar(200), greetings varchar(200))
insert into #temp(studid, studname)
exec spname @param1 (after execute the sp it returns the records of column studid, studname)
But i want to pass constant value in the procedure and insert into the #temp table (greetings column)
insert into #temp(studid, studname, greetings)
exec spname @param1, 'Hello'
Please how can i achieve this?
Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/