UFN_BBIS_GETCLIENTSITEID

Returns the integer ID for the specified BBIS client site

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_BBIS_GETCLIENTSITEID(@ID uniqueidentifier)
returns int
as begin
    return coalesce((select top 1 ID from dbo.CLIENTSITES where GUID = @ID), 0);    
end