asked on
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
reportbuilderparameters.png
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
TRUSTED BY