UFN_GET_REGISTRANTCOUNT_BY_PRICEID

        create function dbo.UFN_GET_REGISTRANTCOUNT_BY_PRICEID(@PRICEID int)
        returns int
        with execute as caller
        as begin
            return (select REGISTRATIONCOUNT from dbo.EVENTPRICE as EP 
                    inner join dbo.BBNCEVENTPRICEIDMAP as BEP on BEP.EVENTPRICEID =EP.ID
                    where BEP.ID =@PRICEID)
        end