USP_DATAFORMTEMPLATE_VIEW_FLATTENEDRESERVATIONHEADER

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FLATTENEDRESERVATIONHEADER
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ARRIVALDATE date = null output,
    @SALESORDERSTATUSCODE tinyint = null output,
    @SALESORDERSTATUS nvarchar(max) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select
        @DATALOADED = 1,
        @ARRIVALDATE = RESERVATION.ARRIVALDATE,
        @SALESORDERSTATUSCODE = SALESORDER.STATUSCODE,
        @SALESORDERSTATUS = SALESORDER.STATUS
    from
        dbo.RESERVATION
    inner join
        dbo.SALESORDER on SALESORDER.ID = RESERVATION.ID
    where
        RESERVATION.ID = @ID;

    return 0;