Subscription Emailing report when it shouldnt....or when its not desired

  • I have a datadriven subscription that uses a stored procedure.

    The code is below:

    declare @ReturnValue int

    exec @ReturnValue = s003pSRC.sp_Par_Rate_Compare_Report_Subscription_Condition

    select @ReturnValue ReturnValue

    I have run the sp in ssms and I know its returning a 0 int value, why is the report still being sent out?

  • dndaughtery (5/21/2013)


    I have a datadriven subscription that uses a stored procedure.

    The code is below:

    declare @ReturnValue int

    exec @ReturnValue = s003pSRC.sp_Par_Rate_Compare_Report_Subscription_Condition

    select @ReturnValue ReturnValue

    I have run the sp in ssms and I know its returning a 0 int value, why is the report still being sent out?

    what do you think the return value represents?

    by default, unless you modified the procedure to return a an integer determined within the stored procedure(ie return @@rowcount), a procedure returns zero when there are no errors.

    Where in your code are you validating whether a subscription should be sent or not?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • It returns an int value 1 or 0

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply