USP_DATAFORMTEMPLATE_EDITLOAD_RESERVATIONPRICING

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RESERVATIONPRICING (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @PRICINGCODE tinyint = null output,
    @RATESCALEID uniqueidentifier = null output,
    @TOTALVISITORCOUNT int = null output,
    @RATESCALEPRICES xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @PRICINGCODE = PRICINGCODE,
        @TOTALVISITORCOUNT = dbo.UFN_RESERVATION_TOTALVISITORCOUNT(ID)
    from
        dbo.RESERVATION
    where
        ID = @ID;

    if @PRICINGCODE = 1 begin  -- Flat rate
        select @RATESCALEID = RATESCALEID from dbo.RESERVATIONRATESCALE where ID = @ID;
    end

    set @RATESCALEPRICES = (
        select
            RATESCALEPRICE.RATESCALEID as [@RATESCALEID],
            RATESCALEPRICE.AMOUNT as [@AMOUNT],
            RATESCALEPRICE.GROUPMINIMUM as [@GROUPMINIMUM],
            RATESCALEPRICE.GROUPMAXIMUM as [@GROUPMAXIMUM],
            RATESCALE.USEPERTICKETAFTERMAX as [@USEPERTICKETAFTERMAX]
        from
            dbo.RATESCALEPRICE
        inner join
            dbo.RATESCALE on RATESCALE.ID = RATESCALEPRICE.RATESCALEID
        for xml path('ITEM'), type, elements, root('RATESCALEPRICES'), binary base64
    );

    return 0;