USP_SENDMAXREACHEDNOTIFICATIONCONDITION_GET

create procedure dbo.USP_SENDMAXREACHEDNOTIFICATIONCONDITION_GET
(
    @EventPriceID uniqueidentifier,
    @SendEventContactAlertMaxReached bit = 0 output,
    @AvailableQuantity int = null output
)
as
begin
  set nocount on;

    select @SendEventContactAlertMaxReached = SENDEVENTCONTACTALERTMAXREACHED,
         @AvailableQuantity = (case MAXQUANTITY 
                              when 0 then 2147483647 
                              else MAXQUANTITY-USEDQUANTITY end) 
  from dbo.FAFREGISTRATIONTYPE 
  where EVENTPRICEID = @EventPriceID

  return 0;
end