IF (Exists(select Table_name from SysTable where LCase(Table_name)=LCase('v_New_StatisticsByCountry1'))) THEN
  Drop view v_New_StatisticsByCountry1
END IF

Go

Create View v_New_StatisticsByCountry1 as

Select Distinct
  NewLodgings,
  DateReg,
  Room,
  Description
from v_New_StatisticsByCountry
// pomoshtno view za spravkata "statistika po strani"
//[17.August.2006] - Yanko