Posted by Trevor Bishop on 01/10/07 02:13

I'm having problems calling my second proc (MyProcedure2) from within an
existing proc. MyProcedure2 does not seeem to fire this way. My code is
below. Help appreciated.

Thanks,
Trevor

ALTER procedure dbo.MyProcedure1
(@newsletterid int)
AS
SET NOCOUNT ON
-- Return Subscribers
declare @howmany int
set @howmany=isnull((select count(subscriberid) from mySubscribers where
newsletterid=@newsletterid),0)
update Mynewsletters set status=3,howmany=@howmany where
newsletterid=@newsletterid
select @howmany

exec MyProcedure2



*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Visa Encryption with Sql Server
• Prev in forum: Re: Import flat file into SQL Server 2005 Express
• Thread view: Calling a Proc From a Proc

[Reply to this message]