Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
DECLARE @vkGotovina AS FLOAT;
DECLARE @vkProvGotovina AS FLOAT;
DECLARE @vkFaktura AS FLOAT;
SELECT @vkGotovina=SUM(rcKolicina_R * rcBruto_R),
@vkProvGotovina=SUM(rcKolicina_R * rcProvizija_R),
@vkFaktura=SUM(rcKolicina_Fak_R * rcProvizija_Fak_R),
SUM(rcKolicina_Fak_R * rcProvizija_Fak_R) AS vkProvFaktura
FROM tblRezervacii
INNER JOIN
tblRezervacii_Cenovnik ON tblRez