UFN_SITEPAGE_BBPAYTEMPLATEVERSION_ARE_ALL_ON_VERSION

create function dbo.UFN_SITEPAGE_BBPAYTEMPLATEVERSION_ARE_ALL_ON_VERSION
(
    @BBPAYTEMPLATEVERSION smallint,
  @ENVIRONMENTID uniqueidentifier
)
returns bit
as
begin
    declare @OTHER_VERSIONS_FOUND bit = 0;
    select @OTHER_VERSIONS_FOUND = 1 from dbo.CMSSITEPAGEBBPAYTEMPLATEVERSION where BBPAYTEMPLATEVERSION <> @BBPAYTEMPLATEVERSION and EnvironmentId = @ENVIRONMENTID;
    return ~@OTHER_VERSIONS_FOUND;
end