Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-28 : 07:58:41
|
| Asif writes "Hi, i thought this would be an easy question to answer hwoever i have not been able to find an answer so i submit my question to you, the experts.Basically I have a database that keeps all the users personal data in one table however the usertypes are stored in a seperate table, what happens is different users can come and subscribe to different services from different pages, when they do subscribe depending on the type of user they are, different data is added to different tables (along with the users personal data). On each of these subscription pages i could create stored procedures which do the insert however i would have to replicate this numerous times for each subscription page. Is there a way by which i can simply create one stored procedure to do the insert of the users personal data, and access this from another stored procedure which does the insertion of the user personal data and the sepecifc usertype insertions." |
|
|
|
|
|
Accessing a Stored Procedure form within a Stored Procedure