How can I call a stored procedure from another stored procedure

Question

I have two store procedures, in one of them I want to get one field form my view that has a Date value.

In the another one which is called StoredProcedure I want to convert the output value of first stored procedure to Hijri Shamsi Date:

This is my first stored procedure that gets the date column:

ALTER PROCEDURE GetExamDate 
    @Id INT
AS
    SELECT ExamTime 
    FROM View_SubjectStudyCourse
    WHERE @Id = CourseId
GO

and then I want to use the below code in the second procedure to converts the Gregorian date to Hijri date is:

DECLARE @DateTime AS DATETIME
SET @DateTime = GETDATE()

SELECT 
    @DateTime AS [Gregorian Date],
    CONVERT(VARCHAR(11), @DateTime, 131) AS [Gregorian date to Hijri date]
GO

Now I don't know how to use the above code in second stored procedure and how can I return value of the GetExamDate Procedure in the second procedure?!

Which dbms are you using? (That code is product specific.) – jarlh May 09 '19 at 06:36 — jarlh, May 09 '19 at 06:36

score 1 · Accepted Answer · answered May 09 '19 at 06:40

1

In First Stored Procedure, return the date as an out parameter

In Second Stored Procedure,

DECLARE @examDate DateTime
EXECUTE GetExamDate @examDate OUTPUT

Then you can use the value of @examDate, which is the result from 1st SP.

answered May 09 '19 at 06:40

Habeeb

7,601
1
30
33

@dorsa: hope this helped. If so please mark it an an answer so that it helps anyone who refers to it later. – Habeeb May 09 '19 at 08:36
Thx Habeeb, I do that.but how can I call the 1st SP in the second SP?! – dorsa May 11 '19 at 09:10
@dorsa, the above example is the way you call the 1st SP in the 2nd SP. – Habeeb May 12 '19 at 05:18

How can I call a stored procedure from another stored procedure

1 Answers1