CREATE PROCEDURE dbo.OnlineFindMaxpax  @OnlineRoomtypenumber INT , @TotalMaxpax INT OUTPUT AS
SET NOCOUNT ON
/*
    Created by Troels Buch Jun 2005
    
    Changes: 
    TB20070821 - Find MaxPaxTotal from OnlineRoomTypes
    TB20060121 - Load Maxpax fromonlineroomtypes
    TB20050615 - Added NOLOCK to SELECT
    TB20050613 -  Maxpax is taken from Roomtypes instead from onlinemaxpax.
	

    NOTES: 	- 
*/

--TB20060121
--SELECT  TOP 1 @TotalMaxpax =  MaxPax FROM Roomtypes (NOLOCK)  WHERE OnlineRoomtypeNumber = @OnlineRoomtypenumber  ORDER BY MaxPax DESC
--SELECT @TotalMaxpax = MaxPaxTotal FROM OnlineRoomtypes (NOLOCK) WHERE OnlineRoomtypenumber = @OnlineRoomtypenumber

-- TB20070821
SELECT @TotalMaxpax =  MaxPaxTotal FROM OnlineRoomTypes WITH (nolock) WHERE OnlineRoomtypeNumber = @OnlineRoomtypenumber ORDER BY MaxPaxTotal DESC


