UFN_BBNC_GETCONSTITLOOKUPIDFROMMAPID

Return

Return Type
nvarchar(200)

Parameters

Parameter Parameter Type Mode Description
@ID int IN

Definition

Copy


      CREATE function dbo.UFN_BBNC_GETCONSTITLOOKUPIDFROMMAPID(@ID int
            returns nvarchar(200)
            as begin
                return (
                    select top 1 LOOKUPID
                    from dbo.CONSTITUENT
                    where SEQUENCEID = @ID
                    )
            end