cancel
Showing results for 
Search instead for 
Did you mean: 

Attribute name "EMPID" different from Attribute name: "EmpId"

0 Kudos

My function is here and attribute name in not different from attiribute nama!

CREATE FUNCTION "HS_getMaasHesapla"(EmpId int,MaasTuru varchar(1),Donem varchar(50),SablonCode varchar(50),
Maas decimal(18,6),Brut decimal(18,6),Pek decimal(18,6),NetEkKazanc decimal(18,6),BrutEkKazanc decimal(18,6), 
EkKesinti decimal(18,6),DvrGvMatrah decimal(18,6),SonBrutMaas decimal(18,6),HesaplananMatrah decimal(18,6),
IzinTutar decimal(18,6),MesaiTutar decimal(18,6),Agi decimal(18,6),IsBes varchar(1),IsIcra varchar(1),donembasi DATE,
donemsonu DATE)
RETURNS TABLE(EmpId INT, GVMatrah decimal(18,6),Brut decimal(18,6),SGKIsv decimal(18,6),IszCal decimal(18,6),IszIsv decimal(18,6)
,SGKCal decimal(18,6),GV decimal(18,6),DV decimal(18,6),Net decimal(18,6),EkKazanc decimal(18,6),Pek decimal(18,6),
IzinTutar decimal(18,6),Bes decimal(18,6),Icra decimal(18,6),Odenen decimal(18,6),Maliyet decimal(18,6),
EkKesinti decimal(18,6),Mesai decimal(18,6),IcraOran decimal(18,6),DosyaNumarasi varchar(50))
LANGUAGE SQLSCRIPT
SQL SECURITY DEFINER
AS
BEGIN
Declare SGKIsv decimal(18,6);          
Declare IszCal decimal(18,6);
Declare IszIsv decimal(18,6);
Declare SGKCal decimal(18,6);
Declare GV decimal(18,6);
Declare DV decimal(18,6);
Declare Net decimal(18,6);
Declare GvMatrah decimal(18,6);
Declare EkKazanc decimal(18,6);
Declare Odenen decimal(18,6);
Declare Maliyet decimal(18,6);
Declare Bes decimal(18,6);
Declare Icra decimal(18,6);
Declare IcraOran decimal(18,6);
Declare Mesai decimal(18,6);
Declare MesaiVarmi varchar(1);
Declare MesaiSekli varchar(1);
Declare DosyaNumarasi varchar(50);
Declare SGKMatrah decimal(18,6);
DECLARE Tanim CHAR(1);
DECLARE Tanim2 CHAR(1);
DECLARE Tanim3 CHAR(1);
DECLARE RET DECIMAL(18,6);
RETURN SELECT ROUND(:EmpId, 2) AS "EmpId" ,ROUND(:GVMatrah, 2) AS "GVMatrah",ROUND(:Brut,2) AS "Brut",
ROUND(:SGKIsv,2) AS "SGKIsv", ROUND(:IszCal,2) AS "IszCal",ROUND(:IszIsv,2) AS "IszIsv",ROUND(:SGKCal, 2) AS "SGKCal",
ROUND(:GV, 2) AS "GV",ROUND(:DV,2) AS "DV",ROUND(:Net,2) AS "Net",ROUND(:EkKazanc,2) AS "EkKazanc",
ROUND(:Pek,2) AS "Pek", ROUND (:IzinTutar,2) AS "IzinTutar",ROUND(:Bes,2) AS "Bes" , ROUND(:Icra,2) AS "Icra",
ROUND(:Odenen, 2) AS "Odenen", ROUND(:Maliyet, 2) AS "Maliyet",ROUND(:EkKesinti,2) AS "EkKesinti" ,
ROUND(:Mesai,2) AS "Mesai",ROUND(:IcraOran,2) AS "IcraOran",ROUND(:DosyaNumarasi,2) AS "DosyaNumarasi" FROM DUMMY;


END;




I cant undertand attribute name is not different

Accepted Solutions (0)

Answers (0)