CREATE PROCEDURE dbo.OnlineDeleteRoomline @RoomLine INT AS
SET NOCOUNT ON
/*
    Created by Troels Buch Juni 2004

    Changes: N/A
    JP 20070502 BUG: delete from XTab before table
    AV 2007 0430 addded conferenceline

    NOTES: 	- 

*/

delete from reservationroomlinextab where linenumber = @RoomLine
delete from reservationroomline where linenumber = @RoomLine
delete from reservationConferenceline where ReservationConfLinenumber = @RoomLine


