ed FROM BPS.dbo.tbl_Profile AS p Inner Join  BPS.dbo.tbl_Profile_Mortgage AS pm ON p.Id = pm.FK_ProfileId WHERE p.CaseTypeId IN (0,0,0,00) AND CONVERT(DATE,pm.DateAppIssued,000) BETWEEN @Start AND @End 