Encounters per Year

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 20:06, 5 September 2012 by Troy.Forcier (talk | contribs) (Created page with "Finding the number of annual encounters involves running the following query against the Works DB in SQL: <source lang=TSQL> select count( * ) from encounter where DATEDIFF(day,...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Finding the number of annual encounters involves running the following query against the Works DB in SQL:

select count( * ) from encounter where DATEDIFF(day,encounter.dttm, GETDATE()) < 365