Call SP from within a SP in SQL Server 6.5

[nevets72]

Hi....I want to call a stored procedure from within another stored procedure, but when I go to save the stored procedure, I keep getting:

Invalid object Name 'Rpt_UnderAlloc.'

I'm able to call a View (Rpt_ActForp2), but I can't call the Stored Procedure.....why can't I do this?

Here's my code:

CREATE PROCEDURE Rpt_ActForp @date_val varchar(10) AS
BEGIN
SELECT *
FROM Rpt_UnderAlloc
Where Date <= @date_val AND
DatePart(yy,Date) = DatePart(yy,@date_val)
UNION ALL
SELECT *
FROM Rpt_ActForp2
Where Date > @date_val AND
DatePart(yy,Date) = DatePart(yy,@date_val)

END
GO

 

[tlbroadbent]

Is Rpt_UnderAlloc a Stored Procedure? you can't select records from a stored procedure. Yuo execute stored procedures. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.