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 ***

[Back to original message]