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

GO

create view
  DBA.v_RegAllServicesPeriod
  as select v_RegServicesPeriod.RegDate,
    /*Maria +, 1728*/
    v_RegServicesPeriod.RealDateTime,
    /*Maria -*/
    v_RegServicesPeriod.GuestName,
    v_RegServicesPeriod.Account,
    v_RegServicesPeriod.RoomNo,
    v_RegServicesPeriod.Service,
	S.ServiceName,
    v_RegServicesPeriod.ServicesNum,
    ServiceSngPrice,
    v_RegServicesPeriod.AllSum,
    v_RegServicesPeriod.Plateni,
    Dogovor,
    v_RegServicesPeriod.Admin 
from
    DBA.v_RegServicesPeriod, Services S
	where v_RegServicesPeriod.ServiceNo=S.ServiceNo
//[v 00.07.12]
//[v1 21.12.2007, Maria] - dobavena kolona, vzimat se realnata data i chas

go

if (not exists(select N from Relations where TableName='v_RegAllServicesPeriod' and ColName='ServiceName')) then
  INSERT INTO Relations(TableName,ColName,BGTableName,BGColName,RelationTable,RelationCol,SelectCol,N,Function,Suma,Mask,Align,Sortirane,Zadaljitelna,Promenliva,FilterList,DftFilter,Shirina,Opisanie,DftLike,AutoStretch,Spravka,PoslData)
    VALUES('v_RegAllServicesPeriod','ServiceName','Регистрирани услуги','Име услуга','Registered Services','ServiceName',2,GetFreeNInRelations('Registered Services', Null, Null, 3),'ServiceName','','',0,0,'','','','',100,'',0,0,1,today(*))
end if

go