Stored Procedure

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