ERROR 2026-05-04 15:32:15,748 
 Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.
Incorrect syntax near the keyword 'AND'.
SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY ES.NAMEOFESTABLISHMENT ASC) AS hdn_ROW, 
									ISNULL(ES.ParentEstablishmentName,'') AS ParentEstablishmentName,
								dbo.udf_ExpandDigits(ES.NameofEstablishment, 5, '0') AS hdn_Order,
                                    ES.[NAMEOFESTABLISHMENT] as [NameofEstablishment],
                                    ES.[ID] as [ID],
                                     ISNULL(ES.NaturezaId_CH_tblMastNatureza,0) as [ObjectType],
                                    ISNULL(ES.ParentId,0) as [ParentId], 
                                    ES.ID_PI_Entity as [ID_PI_Entity], 
                                     ISNULL(NA.[Description],'') as [ObjectTypeDescription],
									ISNULL(ES.Latitude,'') as [Latitude],
									ISNULL(ES.Longitude,'') as [Longitude],
									ISNULL(ES.AssetNumber, '') as AssetNumber,	ISNULL(ES.NIF, '') as ObjectNIF,
									ISNULL(EN.NIF, '') as NIF,
									ISNULL(EN.Name, '') as EntityName,
									ISNULL(ES.CUIId, '') as CUIId,
									(case RTRIM(LTRIM(ISNULL(ES.[Addresses],''))) when '' then '' else ' ' + ES.[Addresses] END   
									+ case RTRIM(LTRIM(ISNULL(ES.DoorNo,''))) when '' then '' else ', ' + ES.DoorNo END   
									+ case RTRIM(LTRIM(ISNULL(ES.Floor,''))) when '' then '' else ', ' + ES.Floor END   
									+ case RTRIM(LTRIM(ISNULL(ES.Block,''))) when '' then '' else ', ' + ES.Block END   
									+ case RTRIM(LTRIM(ISNULL(ES.PostalCode,''))) when '' then '' else ', ' + ES.PostalCode END) as [Address],
									CASE WHEN EXISTS ( SELECT 1 FROM PI_TblMasterServiceType PS WHERE PS.DependencyScheduling = 1 AND PS.PIServiceTypeId IN (SELECT Element FROM #tempProductIDs)    )
									AND DEP.ProjectName IS NOT NULL    THEN 1     ELSE 0 END AS DependencyObject,
									ISNULL(DEP.ProjectName, '') AS DependencyProjectName,
									ISNULL(DEP1.DepInspectionCount, 0) AS DepInspectionCount
                                    FROM PI_Establishment ES 
									
									inner join EnterpriseEntity EE on ES.ID_PI_Entity=EE.ID_PI_Entity
                                    
                                    INNER join PI_Entity EN on EN.ID=ES.ID_PI_Entity 
                                    left join CH_tblMastNatureza NA on NA.NaturezaId = ES.NaturezaId_CH_tblMastNatureza 
									OUTER APPLY (    SELECT TOP 1 
										P.ProjectName +' Requested by: '+ EB.EmployeeName +' Created on:'+ CONVERT(VARCHAR(10),P.CreationDate,103) AS ProjectName
										FROM PI_Establishment D
										INNER JOIN CH_tblProjectObjects PO ON PO.EstablishmentID = D.ID 
										INNER JOIN CH_tblProjectBasics P ON P.ProjectId = PO.ProjectId
										LEFT JOIN CH_tblEmployeeBasics EB ON P.CreatorUserId = EB.EmployeeId
										WHERE P.PIServiceTypeID =  AND D.ID = TRY_CAST(ES.Features AS BIGINT) AND P.StatusID_PI_StatusInformation Not IN( 10,8) and P.StatusID_PI_StatusInformation IS NOT NULL AND PO.EstablishmentID IS NOT NULL  ORDER BY P.CreationDate ASC
									) DEP
									OUTER APPLY ( SELECT COUNT(*) AS DepInspectionCount  FROM PI_Establishment D
										 INNER JOIN CH_tblProjectObjects PO 
										   ON PO.EstablishmentID = D.ID
										  INNER JOIN CH_tblProjectBasics P 
								    ON P.ProjectId = PO.ProjectId
							   WHERE  P.PIServiceTypeID =  AND D.ID = TRY_CAST(ES.Features AS BIGINT)  AND P.StatusID_PI_StatusInformation Not IN( 10,8) and P.StatusID_PI_StatusInformation IS NOT NULL  AND PO.EstablishmentID IS NOT NULL) DEP1
                                    where EE.ClientID_CH_tblClientBasic = 4 and  ISnull(ES.IsAudit,0) != 1 and ES.IsDeleted=0   AND (NameofEstablishment like '%506736466%' OR ISNULL(ES.[Addresses],'') Like '%506736466%' 
										OR  ISNULL(ES.DoorNo,'') Like '%506736466%' OR  ISNULL(ES.Floor,'') Like '%506736466%'
										OR  ISNULL(ES.Block,'') Like '%506736466%' OR  ISNULL(ES.PostalCode,'') Like '%506736466%' OR  ISNULL(ES.AssetNumber,'') Like '%506736466%' OR  ISNUL : PI.Data:- DLADOConnection

---------------------------------------------------------------------------------------------

ERROR 2026-05-11 10:17:17,129 
 Procedure or function udp_CreateReInspection has too many arguments specified. : CH.Data:- DLADOConnection

---------------------------------------------------------------------------------------------

ERROR 2026-05-11 10:19:32,347 
 Procedure or function udp_CreateReInspection has too many arguments specified. : CH.Data:- DLADOConnection

---------------------------------------------------------------------------------------------

ERROR 2026-05-11 10:20:27,694 
 Procedure or function udp_CreateReInspection has too many arguments specified. : CH.Data:- DLADOConnection

---------------------------------------------------------------------------------------------

ERROR 2026-05-11 10:30:37,067 
 Procedure or function udp_CreateReInspection has too many arguments specified. : CH.Data:- DLADOConnection

---------------------------------------------------------------------------------------------

ERROR 2026-05-11 10:31:33,429 
 Procedure or function udp_CreateReInspection has too many arguments specified. : CH.Data:- DLADOConnection

---------------------------------------------------------------------------------------------