CREATEORREPLACEFUNCTIONGT_MaxDataVisualitza(@professionalIdint=0)RETURNSdateASBEGINdeclare@modaint;declare@modalitatint;declare@fiDatadate;declare@MaxDatadate;declare@dataActivadate;declare@diaActivaint;declare@finsdate;declare@divisioSIPvarchar(2);select@moda=con.NomenamentId,@modalitat=con.modalitatId,@fiData=con.FiData,@divisioSIP=up.divisioSIPfromCTR_ContractesasconleftouterjoinGNR_UPSasuponup.UPID=con.UPIdWHEREGETDATE()BETWEENIniciDataandFiDataANDcon.EsActiu=1andProfessionalID=@professionalId;select@diaActiva=convert(int,Valor)fromGT_ParametresWHERENom='VisualitzaMesSegüent';Select@dataActiva=convert(date,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(GETDATE())-1)+@diaActiva-1,GETDATE()),103),103);-- si es abans del dia d'activació, només veiem fins a finals de mes IF@dataActiva>GETDATE()SET@fins=convert(date,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,1,GETDATE())),103),103)-- si no fins a finals del mes següentELSESET@fins=convert(date,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,2,GETDATE())),103),103)-- ESTATUTARI IF@professionalId=0SET@MaxData=@finsELSEIF@moda=1SET@MaxData='9999-12-31'ELSEIF@moda=3and@modalitat=2SET@MaxData='9999-12-31'ELSEIF@divisioSIP<>'H4'set@MaxData='9999-12-31'ELSEIF@fiData>@finsSET@MaxData=@finsELSESET@MaxData=@fiData;RETURN@MaxDataENDGO;
b is empty. How can I debug it?
Thx
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Executing: tsql2mysql.exe <a.sql> b.sql</a.sql>
Input file:
b is empty. How can I debug it?
Thx