Call sql stored procedure from a stored procedure

[spDavCom]

Please can anyone show me the correct syntax on how to call a stored proc(requiring params) from a stored proc or let me know if it is even possible. I'm using MSDE and sql server 2000 sP2. ANY, examples would be most appreciated.

 

[topher0303]

Are you refering to this?

Exec SprocName @param1, @param2, @param3

 

[tlbroadbent]

The syntax for executing a stored procedure is the same if you execute in a script or another a another stored proc, The syntax is in SQL BOL. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm