hi all
i don't know how i call the one storedprocedures to another storedprocedures?
if any one knows give me example through reply?
if reply this appricate!
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Bhavik SolankiPosted Apr 10, 2011, 3:41 AM
Hi,
It's very easy let me give you one example
We have 2 procedurer
Given name GetListofCustData , GetListOfCustname
Both return customer related information and required paramitter is same. Let's assue required paramitter is complay id
So we need to call GetListOfCustname in GetListofCustData
So we write code in GetListofCustData
Alter procedurer GetListofCustData
(@companyId int64) as begin
Exec GetListOfCustname @companyId
End