select  distinct PV.VisitNumber ,
                                       P.[Name] as Patient_name,
                                        P.PatientNumber as HLABNO ,
                                        PV.VisitNumber as OID ,
                                        cast(PV.VisitDate as date ),
                                        ClientCode   as CLIENTCD ,
                                    N.Template ,
                    N.AttachmentName
                                        from [lims_live].[dbo].Patient P With (nolock)
                                        Inner join [lims_live].[dbo].PatientVisit PV with(nolock) on PV.PatientID = P.PatientID AND PV.OrganizationID = P.OrganizationID
                                        inner JOIN [lims_live].[dbo].Notifications N With(nolock)   ON  N.OrgID = PV.OrganizationID AND PV.PatientVisitId = N.IdentityID
                                        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


                                        where
                                        N.ActionType = 'Pdf'
                                        and N.Category = 'Report'
                                        and N.Status = 'Completed'
                                        and cm.ClientCode = 'CH368'
                                        and CAST(PV.VisitDate as Date) >= '20181201'
                                        and CAST(PV.VisitDate as Date) <= '20190228'

                                       Order by PV.VisitNumber
 
Array
(
)
END OK...!