string(56) " OrgID1 : 78 ClientCode : C0075 ServerLocation : CHENNAI"
select   
						PV.OrganizationID ,
						PV.PatientVisitID ,
			      Replace(Replace(P.[Name], '(' , '' ) , ')' , '') as Patient_name,
			      left(P.[Name], case when charindex('mrn', P.[Name]) = 0 then len(P.[Name]) +2 else charindex('mrn', P.[Name]) end   - 2) as Pname,
			      P.PatientNumber ,
			      PV.VisitNumber ,
			      CONVERT(VARCHAR(11),PV.VisitDate,106) VisitDate,
			      cm.ClientCode   as ClientCode,
			      cm.ClientName as ClientName,
			      P.EMail as Patient_Email,
			  		N.Template ,   
						N.AttachmentName,
						N.NotificationID,
						cast(N.CompletionTime as date )  as ApprovalDate,
						N.CompletionTime ,
						FB.BillNumber,
						CONVERT(VARCHAR(11), FB.CreatedAt, 106) + ' T' + CONVERT(varchar,FB.CreatedAt ,108) as BillDate
			      from [lims_live].[dbo].[Notifications] N With(nolock) 
			      Inner join [lims_live].[dbo].PatientVisit PV with(nolock) ON  N.OrgID = PV.OrganizationID AND PV.PatientVisitId = N.IdentityID
			      INNER JOIN [lims_live].[dbo].Patient P With(nolock) on PV.PatientID = P.PatientID AND PV.OrganizationID = P.OrganizationID
			      INNER join [lims_live].[dbo].VisitClientMapping VCM With(nolock) on VCM.VisitID = PV.PatientVisitId and VCM.IsActive is null
			      inner join [lims_live].[dbo].ClientMaster Cm With(nolock) on CM.ClientID = VCM.ClientID --and CM.OrgID = VCM.OrgID
			      inner join [LIMS_LIVE].[dbo].FINALBILL FB with(nolock) on FB.[VisitID] = PV.PatientVisitID
				        AND FB.[OrgID] = PV.OrganizationID
				        
			      LEFT JOIN CallHealth_mails CMail with (nolock) ON CMail.OrgID = N.OrgID and CMail.NotificationID = N.NotificationID and N.CompletionTime = CMail.CompletionTime 
			      where
			          N.ActionType  in ( 'Pdf')
						and N.Category = 'Report'    
						and N.Status = 'Completed'
			      and cm.clientCode = 'C0075'
			      AND ISNULL(FB.[RefFinalBillID] , 0) = 0 
			      and PV.OrganizationID   = 78
			      and cast(N.CompletionTime as date ) >= cast(getdate()-5 as date) 
			      and P.Name NOT LIKE '%DUMMY%'
			      AND CMail.NotificationID IS NULL
			      Order by CompletionTime
			      -- FTP::192.168.23.27\/var/www/html/mhl|CallHealthClientReportMailer_AllOrg.php
			      ;
Array
(
)
string(57) " OrgID1 : 107 ClientCode : C0057 ServerLocation : CHENNAI"
select   
						PV.OrganizationID ,
						PV.PatientVisitID ,
			      Replace(Replace(P.[Name], '(' , '' ) , ')' , '') as Patient_name,
			      left(P.[Name], case when charindex('mrn', P.[Name]) = 0 then len(P.[Name]) +2 else charindex('mrn', P.[Name]) end   - 2) as Pname,
			      P.PatientNumber ,
			      PV.VisitNumber ,
			      CONVERT(VARCHAR(11),PV.VisitDate,106) VisitDate,
			      cm.ClientCode   as ClientCode,
			      cm.ClientName as ClientName,
			      P.EMail as Patient_Email,
			  		N.Template ,   
						N.AttachmentName,
						N.NotificationID,
						cast(N.CompletionTime as date )  as ApprovalDate,
						N.CompletionTime ,
						FB.BillNumber,
						CONVERT(VARCHAR(11), FB.CreatedAt, 106) + ' T' + CONVERT(varchar,FB.CreatedAt ,108) as BillDate
			      from [lims_live].[dbo].[Notifications] N With(nolock) 
			      Inner join [lims_live].[dbo].PatientVisit PV with(nolock) ON  N.OrgID = PV.OrganizationID AND PV.PatientVisitId = N.IdentityID
			      INNER JOIN [lims_live].[dbo].Patient P With(nolock) on PV.PatientID = P.PatientID AND PV.OrganizationID = P.OrganizationID
			      INNER join [lims_live].[dbo].VisitClientMapping VCM With(nolock) on VCM.VisitID = PV.PatientVisitId and VCM.IsActive is null
			      inner join [lims_live].[dbo].ClientMaster Cm With(nolock) on CM.ClientID = VCM.ClientID --and CM.OrgID = VCM.OrgID
			      inner join [LIMS_LIVE].[dbo].FINALBILL FB with(nolock) on FB.[VisitID] = PV.PatientVisitID
				        AND FB.[OrgID] = PV.OrganizationID
				        
			      LEFT JOIN CallHealth_mails CMail with (nolock) ON CMail.OrgID = N.OrgID and CMail.NotificationID = N.NotificationID and N.CompletionTime = CMail.CompletionTime 
			      where
			          N.ActionType  in ( 'Pdf')
						and N.Category = 'Report'    
						and N.Status = 'Completed'
			      and cm.clientCode = 'C0057'
			      AND ISNULL(FB.[RefFinalBillID] , 0) = 0 
			      and PV.OrganizationID   = 107
			      and cast(N.CompletionTime as date ) >= cast(getdate()-5 as date) 
			      and P.Name NOT LIKE '%DUMMY%'
			      AND CMail.NotificationID IS NULL
			      Order by CompletionTime
			      -- FTP::192.168.23.27\/var/www/html/mhl|CallHealthClientReportMailer_AllOrg.php
			      ;
Array
(
)
string(55) " OrgID2 : 67 ClientCode : SL017 ServerLocation : MUMBAI"
SQLSTATE[01002] Adaptive Server connection failed (MHLLIMSDB05:1433) (severity 9)SQLSTATE[01002] Adaptive Server connection failed (MHLLIMSDB05:1433) (severity 9)END OK...!