stored procedure

Question

Hi  I have this stored procedure  I want to select empid empname is possible to without change stored procedure. create procedure sp_employee as begin SELECT empid empname empdestination empemail empmobile FROM employee end select empidempnameempmobile exec sp_employee is it correct?

brunda k · Answer

EXEC sp_serveroption 'SERVERNAME' 'DATA ACCESS' TRUE SELECT empidempnameempmobile FROM OPENQUERY ([SERVERNAME]'EXECUTE DatabaseName.dbo.sp_employee') Ref: http://sqlusa.com/bestpractices2005/selectfromsproc/

Vulpes · Answer

You'll need to insert the result set of the stored procedure into a temporary table first and then select from that: INSERT INTO temptable (empid empname empdestination empemail empmobile) EXEC sp_employee SELECT empidempnameempmobile FROM temptable