SQLTeam.com | Weblogs | Forums

Stored Procedure


#1

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


#2

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