I had create two store procedure 1. Sp_collecting data (it's for colllecting data from database) 2. sp_numtoWord (it used for translate numeric to word pharse) i need to combining them,.... please give me tips/sample how to combining/ execute both, thank you...

Firman,

Here are a few options:

Option 1 - New consolidated stored procedure

CREATE PROCEDURE dbo.spConsolidated AS

EXEC dbo.Sp_collecting

EXEC dbo.sp_numtoWord

GO

Option 2 - Copy the code from the second stored procedure to the first stored procedure

Option 3 - Have the first stored procedure call the second stored procedure

CREATE PROCEDURE dbo.Sp_collecting AS

-- Current Code

-- New Code

EXEC dbo.sp_numtoWord

Thank you,
The MSSQLTips.com Team