Skip to Content
0

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

Mar 09 at 09:08 AM

9

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers