[dbo].[GetPlasticWebDealBranchID]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)	Direction
@inMoversConnectId	bigint	8
@outBranchID	varchar(5)	5	Out

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/*
*    Description: Get a plastic web deal's BranchID by knowing it's MoversConnectID
**/
create procedure [dbo].[GetPlasticWebDealBranchID]
    @inMoversConnectId bigint,
    @outBranchID varchar(5) output
as
set nocount on

set @outBranchID = isnull( (
    select top 1    -- There should only be one such record, but there is no guarantee.
        Branch.BranchID
    from PlasticWebDeal
    inner join Branch on Branch.BranchPriKey = PlasticWebDeal.BranchPriKey
    where PlasticWebDeal.MoversConnectFID = @inMoversConnectId
), '' )
GO
GRANT EXECUTE ON  [dbo].[GetPlasticWebDealBranchID] TO [MssExec]
GO