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

GO

create view
  DBA.v_PercentZaetostBeds
  as select DateForecast.FDate,
    RoomCount=DateForecast.RoomCount-(select isnull(Sum(R.NumBeds),0) from DBA.Rooms as R,
                      DBA.RoomStatusForPeriod as RSFP where
                      RSFP.NRoom = R.RoomNum and RSFP.StartDate <= DateForecast.FDate 
		              and RSFP.EndDate >= DateForecast.FDate 
	                  and RSFP.NStatus <> 0 and RSFP.NStatus <> 2),
    DateForecast.CrashedRooms,
    DateForecast.ServiceRooms,
    DateForecast.OwnedRooms,
    Noshtuvki=DateForecast.Elderly+DateForecast.Children,
    PercentZaetost=(Noshtuvki*100/DateForecast.RoomCount) from
    DBA.DateForecast where
    DateForecast."Session" = bvrConnectID
    
//Maria - kolonata RoomCount e promenena da vzima predvid dali za saotvetnata data ima data sus status razlichen ot "normalna" i "nepochistena"