Yes. I am returning an output parameter from the nested procedure.

Here is the code:

CREATE PROCEDURE CP_GetCalendarDates

@EmployeeID INT,

@CaseID INT,

@CustomerID INT

AS

BEGIN

DECLARE

@TransDutyCode INT

CREATE TABLE #CalendarTempTable

(

EventDate datetime,

EventType varchar(15),

ShortDescription varchar(25),

LongDescription varchar(60),

PFirstName varchar(50), ...