how can i call the one storedprocedures to another storedprocedures give me example?

Question

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!

Bhavik Solanki · Answer

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