UFN_BBNC_GETMAPID_BYTRANSACTION

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONID	int	IN
@TRANSACTIONTYPE	nvarchar(100)	IN

Definition

Copy



      create function dbo.UFN_BBNC_GETMAPID_BYTRANSACTION(@TRANSACTIONID int, @TRANSACTIONTYPE nvarchar(100))
      returns int
      as begin
          return(
          select Top 1 ID from Transactions where TransactionID = @TRANSACTIONID and TransactionType = @TRANSACTIONTYPE
        )
      end