USP_DATALIST_RESERVATIONSTATUSHISTORY

Returns a list representing the status history of a reservation.

Parameters

Parameter	Parameter Type	Mode	Description
@RESERVATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_RESERVATIONSTATUSHISTORY(@RESERVATIONID uniqueidentifier)
            as
                set nocount on;

                select ID,
                    STATUSDATE,
                    STATUS,
                    COMMENTS
                from dbo.RESERVATIONSTATUSHISTORY
                where RESERVATIONID = @RESERVATIONID
                order by STATUSDATE;