IF (EXISTS(Select * from sys.systable where LCase(table_name) = LCase('v_RoomsNotForSale')))
THEN Drop view v_RoomsNotForSale
END IF

GO

create view v_RoomsNotForSale as
select distinct R.RoomNum, R.NumBeds from Rooms as R, RoomStatusForPeriod as RSFP 
where RSFP.NRoom=R.RoomNum and RSFP.StartDate <= bvrData2 and RSFP.EndDate >= bvrData1 and RSFP.NStatus<>0 and RSFP.NStatus<>2

//--Maria +, vrushta nomerata na staite, koito v zadaden period ne sa za prodajba