<div>
Possible = yes, but fairly complex. What is the user interface platform you will be using?<br />
<br />
You can get the parameters/data types &nbsp;from INFORMATION_SCHEMA.PARAMET<wbr />ERS.
</div>


<div>
Yes, it's definitely possible, but it would almost certainly require dynamic SQL.<br />
<br />
As to params, SQL has a sys.parameters table that provides the params for you. &nbsp;All you need to do is piggy-back off of that.
</div>


<div>
I thought this was possible.. The table that will hold the SP Names will probably have another related table that will be 1 to many relation table... &nbsp;and will hold the parameters and data types for those sp's. Also each of the SP's listed within that table will already be created.. It will be a separate SP that will execute those based on the passed sp name and parameters that I want to pass into it. Can anyone help me with a jump start on how I would code that master SP to take the parameters that will call the specified SP and its parameters?
</div>


<div>
its going to be a webservice and the service will have an object that is passed within it that would be an available list of the SP's that application that calls the webservice would use to get it to call what ever specific data it needed.
</div>


<div>
So I looking to make an all in-compassing Web Service basically with ever having to write additional calls for the for the service. They would get a dynamic SP list from the object that's passed within the service to specify what they need or want,
</div>


<div>
Walter-- yes I understand what your saying and that's why I'm building Web Service Object (DLL) that will contain the exposed generic/dynamic calls that the object will have to expose the list Of object types that if and when the developers need to add additional SP calls then they add the SPs in to the table with relation to the parameters table to expose new calls as they needed in the future. I'm building this for a portal that will have the ability for junior level developers to easily call functions within &nbsp;the portal to make their portal applications work without stubbing their project environment &nbsp;with Web references and reducing advanced concepts on them for have the whole process of serialize and desterilize for security purposes.
</div>


<div>
@sweoff if i understand it will work in this way from the client<br />
- First calls your webservice method1 that returns a list of the functions(sproc) with their parameters and type.<br />
- Then build an string with the function it needs to call and the parameters with their values encoded in some form.<br />
- Then call &nbsp;webservice method2 which calls the sproc and returns some value.<br />
<br />
Is this correct?
</div>


<div>
<div class="content wysiwyg-content">
Is it or would be possible to create stored procedure that could have a list of parameters to pass the stored procedure name to run and the parameters it needs to run it?<br />
<br />
I need to create a table to define a list of stored procedure names, their parameter names, and the parameter types within a table. As the plan is to call the specified SP from a query to select another SP from the list based on certain selection criteria. Is this even possible and if so how would I go about this? Would there or could there be any possible bottle necks from doing this?
</div>
</div>


Is it or would be possible to create stored procedure that could have a list of parameters to pass the stored procedure name to run and the parameters it needs to run it?

I need to create a table to define a list of stored procedure names, their parameter names, and the parameter types within a table. As the plan is to call the specified SP from a query to select another SP from the list based on certain selection criteria. Is this even possible and if so how would I go about this? Would there or could there be any possible bottle necks from doing this?

Query a table with a list of stored procedures and execute that SP within another SP by passing SP Name and parameteres of it

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Programming theory deals with the design, implementation, analysis, characterization, and classification of programming languages and their individual features, along with introductory programming concepts like program structure, variable declaration and conditional and looping constructs. Sub-disciplines include the formal semantics of programming languages, type theory, program analysis and transformation, comparative programming language analysis, metaprogramming, domain-specific languages, compiler construction and run-time systems.