CREATE PROCEDURE [dbo].[Dental_Assessment] ( @dobstart VARCHAR(8), @dobend VARCHAR(8), @servdatestart VARCHAR(8), @servdateend VARCHAR(8) ) AS select distinct pp.person_id, p.last_name, p.first_name, p.person_nbr,p.date_of_birth from patient_procedure pp inner join person p on pp.person_id = p.person_id where pp.cpt4_code_id in ('D0191','D0120','D0145','D1050','D1080', 'D0140', 'D0160', 'D0170', 'D0171') and p.date_of_birth between @dobstart and @dobend and pp.service_date between @servdatestart and @servdateend
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.