Re: Decide branch doesn’t execute

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Decide branch doesn’t execute › Re: Decide branch doesn’t execute

February 2, 2007 at 4:27 PM #17542
community-content

    Rseroter,

    I tried writing to the event log immediately and I can capture the field on a successful lookup only.  On a failed lookup it's blank.  Here's the stored procedure:

    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    go

    ALTER PROCEDURE [dbo].[TranslateLegacyCustomerNumber]
        (
            @LegacyCustomerNumber nvarchar(255)
        )
    AS
        SET NOCOUNT ON;
       
        SELECT        LegacyCustomerNumber,
                    SAPCustomerNumber,
                    CustomerName
            FROM    CustomerTranslation
            WHERE    LegacyCustomerNumber = @LegacyCustomerNumber
        FOR XML AUTO

        RETURN