if (select count(*) from sys.systable where table_name='SpaServByDays')=0
  then
CREATE TABLE "DBA"."SpaServByDays"
(
        "RowNumber"             integer not NULL,
	"Procedures"  		varchar(20) NULL,
	"A1"    			integer NULL,
	"A2"    			integer NULL,
	"A3"    			integer NULL,
	"A4"    			integer NULL,
	"A5"    			integer NULL,
	"A6"    			integer NULL,
	"A7"    			integer NULL,
	"A8"    			integer NULL,
	"A9"    			integer NULL,
	"A10"   			integer NULL,
	"A11"   			integer NULL,
	"A12"   			integer NULL,
	"A13"   			integer NULL,
	"A14"   			integer NULL,
	"A15"   			integer NULL,
	"A16"   			integer NULL,
	"A17"   			integer NULL,
	"A18"   			integer NULL,
	"A19"   			integer NULL,
	"A20"   			integer NULL,
	"A21"   			integer NULL,
	"A22"   			integer NULL,
	"A23"   			integer NULL,
	"A24"   			integer NULL,
	"A25"   			integer NULL,
	"A26"   			integer NULL,
	"A27"   			integer NULL,
	"A28"   			integer NULL,
	"A29"   			integer NULL,
	"A30"   			integer NULL,
	"A31"   			integer NULL,
        "Total"                         integer NULL
)
end if;

GO

IF (EXISTS (select proc_name from sysprocedure where proc_name='FillSpaPayedServices')) THEN
  DROP procedure FillSpaPayedServices
END IF

GO

create procedure "DBA"."FillSpaPayedServices"(in year integer,in month integer)
begin
  declare @CData integer;
  declare @Broi integer;
  declare @Total decimal(10,4);
  declare @SqlStr varchar(300);
  declare @SqlColumns varchar(300);
  declare @SqlValues varchar(300);
  declare @SqlHeader varchar(300);
  declare @SqlHeaderValues varchar(300);
  declare @Day integer;
  declare @RowNumber integer;
  message '---FillSpaPayedServices---';
  delete from SpaServByDays;
  set @RowNumber=1;
  for f as curs scroll cursor for
    select ServiceNo as @ServiceNo,ServiceName as @ServiceName from Services where ServiceNo in
    (select distinct MedicalService from SpaReservations where ReservetionType=2 and IfPayed=1) do
  set @CData=ymd(year,month,1);
  set @Total=0;
  set @SqlColumns='';
  set @SqlHeaderValues='';
  set @Day=0;
  set @SqlStr='insert into SpaServByDays(RowNumber,Procedures';
  set @SqlValues='';
  while month(@CData)=month loop
    select count(*) into @Broi from SpaReservations where MedicalService=@ServiceNo AND BeginDate=@CData;
    set @CData=days(date(@CData),1);
    set @Day=@Day+1;
    set @Total=@Total+@Broi;
    set @SqlHeaderValues=@SqlHeaderValues||','||CAST(@Day as varchar);
    set @SqlColumns=@SqlColumns||','||'A'+CAST(@Day as varchar);
    set @SqlValues=@SqlValues||','||CAST(@Broi as varchar);
  end loop;
  set @RowNumber=@RowNumber+1;
  set @SqlStr=@SqlStr||@SqlColumns;
  set @SqlHeader=@SqlStr||',Total) values(1,''Процедури'''||@SqlHeaderValues||',''Общо'')';
  set @SqlValues=CAST(@RowNumber as varchar)+','''||@ServiceName||''''||@SqlValues;
  set @SqlStr=@SqlStr||',Total) values('||@SqlValues||','||@Total||')';
  execute immediate @SqlStr;
end for;
end
//[v 11.11.2005] Jorko New procedure

GO

if (Exists (Select Table_name from SysTable where Table_name='v_SpaServicesByDays')) then
  Drop View v_SpaServicesByDays
end if

GO

create view v_SpaServicesByDays as
  select *
  from SpaServByDays
  //order by 1

GO

Delete from Relations where lcase(RelationTable) = lcase('СПА Дневни отчети')

GO

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)
 VALUES('v_SpaServicesByDays','__OPTIONS__','СПА Дневни отчети','__OPTIONS__','СПА Дневни отчети',
        '__OPTIONS__',1,isnull(GetFreeNInRelations('СПА Дневни отчети', Null, Null, 100), 100),'__OPTIONS__','','',0,0,'','','Printer.Orientation=1',
         'call FillSpaPayedServices(bvrYear,bvrMesec)',NULL,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','bvrMesec','СПА Дневни отчети','Месец','СПА Дневни отчети','Месец',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'bvrMesec','','',0,0,'1','1','','select bvrMesec',70,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','bvrYear','СПА Дневни отчети','Година','СПА Дневни отчети','Година',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'bvrYear','','',0,0,'1','1','','select bvrYear', 70,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','Procedures','СПА Дневни отчети','Процедури','СПА Дневни отчети','Процедури',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Procedures','','',0,0,'','','','',160,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A1','СПА Дневни отчети','1','СПА Дневни отчети','1',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A1)','Sum(qrData.1)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A2','СПА Дневни отчети','2','СПА Дневни отчети','2',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A2)','Sum(qrData.2)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A3','СПА Дневни отчети','3','СПА Дневни отчети','3',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A3)','Sum(qrData.3)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A4','СПА Дневни отчети','4','СПА Дневни отчети','4',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A4)','Sum(qrData.4)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A5','СПА Дневни отчети','5','СПА Дневни отчети','5',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A5)','Sum(qrData.5)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A6','СПА Дневни отчети','6','СПА Дневни отчети','6',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A6)','Sum(qrData.6)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A7','СПА Дневни отчети','7','СПА Дневни отчети','7',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A7)','Sum(qrData.7)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A8','СПА Дневни отчети','8','СПА Дневни отчети','8',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A8)','Sum(qrData.8)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A9','СПА Дневни отчети','9','СПА Дневни отчети','9',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A9)','Sum(qrData.9)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A10','СПА Дневни отчети','10','СПА Дневни отчети','10',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A10)','Sum(qrData.10)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A11','СПА Дневни отчети','11','СПА Дневни отчети','11',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A11)','Sum(qrData.11)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A12','СПА Дневни отчети','12','СПА Дневни отчети','12',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A12)','Sum(qrData.12)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A13','СПА Дневни отчети','13','СПА Дневни отчети','13',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A13)','Sum(qrData.13)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A14','СПА Дневни отчети','14','СПА Дневни отчети','14',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A14)','Sum(qrData.14)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A15','СПА Дневни отчети','15','СПА Дневни отчети','15',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A15)','Sum(qrData.15)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A16','СПА Дневни отчети','16','СПА Дневни отчети','16',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A16)','Sum(qrData.16)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A17','СПА Дневни отчети','17','СПА Дневни отчети','17',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A17)','Sum(qrData.17)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A18','СПА Дневни отчети','18','СПА Дневни отчети','18',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A18)','Sum(qrData.18)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A19','СПА Дневни отчети','19','СПА Дневни отчети','19',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A19)','Sum(qrData.19)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A20','СПА Дневни отчети','20','СПА Дневни отчети','20',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A20)','Sum(qrData.20)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A21','СПА Дневни отчети','21','СПА Дневни отчети','21',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A21)','Sum(qrData.21)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A22','СПА Дневни отчети','22','СПА Дневни отчети','22',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A22)','Sum(qrData.22)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A23','СПА Дневни отчети','23','СПА Дневни отчети','23',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A23)','Sum(qrData.23)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A24','СПА Дневни отчети','24','СПА Дневни отчети','24',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A24)','Sum(qrData.24)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A25','СПА Дневни отчети','25','СПА Дневни отчети','25',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A25)','Sum(qrData.25)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A26','СПА Дневни отчети','26','СПА Дневни отчети','26',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A26)','Sum(qrData.26)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A27','СПА Дневни отчети','27','СПА Дневни отчети','27',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A27)','Sum(qrData.27)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A28','СПА Дневни отчети','28','СПА Дневни отчети','28',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A28)','Sum(qrData.28)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A29','СПА Дневни отчети','29','СПА Дневни отчети','29',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A29)','Sum(qrData.29)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A30','СПА Дневни отчети','30','СПА Дневни отчети','30',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A30)','Sum(qrData.30)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','A31','СПА Дневни отчети','31','СПА Дневни отчети','31',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(A31)','Sum(qrData.31)','',1,0,'','','','',25,'',0,0,1)

GO

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)
 VALUES('v_SpaServicesByDays','Total','СПА Дневни отчети','Общо:','СПА Дневни отчети','Общо:',2,GetFreeNInRelations('СПА Дневни отчети', Null, Null, 10),
        'Sum(Total)','Sum(qrData.Общо:)','',1,0,'','','','',50,'',0,0,1)

GO

Call InsertPravaSpravki('СПА Дневни отчети');