Hi
I have stored procedure
select empid,empname,address,city,state. . I want to store the value of empid in another table in same stored procedure
Thanks
Hi
I have stored procedure
select empid,empname,address,city,state. . I want to store the value of empid in another table in same stored procedure
Thanks
Look at INSERT INTO.
Note that you provided a query not the stored procedure so I do not know what all is being done in the SP