Hi, I have the following code which when I execute gives duplicate records. I tried to use the Distinct command but still it took over 1 minute to yield results, thought it yields the right results..Why is it taking such a long long time.. When I remove the Distinct command it takes 3 seconds and yields duplicate records.. Any help pleaseSELECT Distinct TOP (100) PERCENT dbo.tblProjects.ISACProtocol, dbo.tblProjectScheduleEv.EvTypeID, dbo.tblProjectScheduleEv.EvDate, dbo.tblProjectScheduleEv.EvBFDate, dbo.tblProjects.CompletionDt, dbo.tblProjectScheduleEv.RemLetterGenDate, dbo.tblProjects.ProjectDesc, dbo.qrycrtspsheetall.prac_no, dbo.qrycrtspsheetall.main_doctor, dbo.qrycrtspsheetall.address1, dbo.qrycrtspsheetall.address2, dbo.qrycrtspsheetall.address3, dbo.qrycrtspsheetall.town, dbo.qrycrtspsheetall.county, dbo.qrycrtspsheetall.post_codeFROM dbo.tblCurrProj INNER JOIN dbo.qrycrtspsheetall ON dbo.tblCurrProj.Curr_ProjectID = dbo.qrycrtspsheetall.ProjectID INNER JOIN dbo.tblProjectScheduleEv INNER JOIN dbo.tblProjectPractices ON dbo.tblProjectScheduleEv.ProjectPracticeID = dbo.tblProjectPractices.ProjectPracticeID INNER JOIN dbo.tblProjects ON dbo.tblProjectPractices.ProjectID = dbo.tblProjects.ProjectID INNER JOIN dbo.tblProjectPatients ON dbo.tblProjects.ProjectID = dbo.tblProjectPatients.ProjectID INNER JOIN dbo.qryMaxEvTypeID ON dbo.tblProjects.ProjectID = dbo.qryMaxEvTypeID.ProjectID AND dbo.tblProjectScheduleEv.EvTypeID = dbo.qryMaxEvTypeID.MaxEvTypeID ON dbo.qrycrtspsheetall.ProjectID = dbo.tblProjects.ProjectID AND dbo.qrycrtspsheetall.prac_no = dbo.tblProjectPractices.Prac_no AND dbo.qrycrtspsheetall.prac_no = dbo.tblProjectPatients.Prac_noWHERE (dbo.tblProjects.ProjectStatus = 'True') AND (dbo.tblProjectPatients.No = 'true')
Duplicate records
Posted - 2010-08-27 : 09:44:06
