UFN_RESOURCE_FORMATPERTICKETQUANTITY

Returns a description of the per-ticket quantity of a resource

Return

Return Type
nvarchar(25)

Parameters

Parameter	Parameter Type	Mode	Description
@RESOURCES	int	IN
@TICKETS	int	IN

Definition

Copy



CREATE function dbo.UFN_RESOURCE_FORMATPERTICKETQUANTITY
(
    @RESOURCES int,
    @TICKETS int
)
returns nvarchar(25)
with schemabinding, execute as caller
as begin

    if @RESOURCES < 1 --Not a per-ticket item

    begin
        return '';
    end
    else
    begin
        if @TICKETS > 1
        begin
            return convert(nvarchar(6), @RESOURCES) + ' per ' + convert(nvarchar(6), @TICKETS) + ' tickets';
        end
        else
        begin
            return convert(nvarchar(6), @RESOURCES);
        end
    end

    return ''
end