December 13, 2013 at 9:39 am
There is a SQL database that I have read access (can run a query) but can't modify stored procedures, etc. I have complex stored procedure that I run against that database, then I cut/paste the results into Excel. The stored procedure requires modification from time to time otherwise I'd have the DBA add it as a procedure in that database.
Is there a way I can embed the stored procedure into Excel and have it automatically update the spreadsheet? I've played around with Excel, made the connection to the server but can't seem to figure out how to make the stored procedure part of the Excel sheet.
Thanks
December 13, 2013 at 9:44 am
you could create a temporary stored procedure.
whether you can do it through excel, i'm not sure, but thios example works just fine; your proc obviously woudl be more complex
CREATE PROCEDURE #tmp
AS
SELECT top 10 * FROM EDLogDetail ORDER BY EDLogDetailId DESC
GO
EXEC #tmp
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply