How to import stored procedure result to the Excel sheet

[jack1257]

Hi

How to import the stored procedure result to the excel sheet.please provide stored procedure code

[Jerry Winston]

Just use Export wizard in SSMS.

Choose 'write a query to export data' instead of 'Tables and views'. Run the query

EXE [mySchema].[sp_mySP]

[jack1257]

plz give me the stored procedure code with columns display on excel

[Jerry Winston]

I'm not sure what you're looking for. Are you looking for the code of any stored procedure or how do columns map from the stored procedure to the Excel?

[NeoPa]

Jack, as a general rule we don't provide boiler-plate solutions. This is heavily discouraged on the site, especially where members show no signs of having tried anything for themselves.

Other than that of course, your request makes little sense. How can we, or anyone, provide the code for a stored procedure in your database without any sort of specification as to what is even required of the stored procedure? Let alone any information as to the data available to manipulate.