February 1, 2012 at 9:21 am
Greetings dearest Experts,
I am not sure if this is possible but I will ask anyway.
I have built about 9 different simple Stored Procs to display various reports and they work fine.
What I would like to do if possible, is to be able to display a report based on the name of the stored proc.
For instance, I have a dropdown that shows the names of the stored procs, "GetTotalRecs", "OneTime", etc.
These names on the dropdown match the names of the stored procs.
Is it possible to do a query that displays records where name on the dropdown matches any of the names of the store procs?
Hope I am explaining it well. If not, please let me know.
Many thanks
February 1, 2012 at 9:25 am
If I understand you correctly this may help:-
SELECT
name
FROM
testdb.sys.sysobjects
WHERE
xtype = 'p'
where testdb is the name of the database where your stored procedures are.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply