Difference between revisions of "Encounters per Year"
Jump to navigation
Jump to search
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,...") |
|||
Line 1: | Line 1: | ||
− | Finding the number of annual encounters involves running the following query against the Works DB in SQL: | + | Finding the number of annual [[Encounter_Type | encounters]] involves running the following query against the Works DB in SQL: |
<source lang=TSQL> | <source lang=TSQL> | ||
select count( * ) from encounter where DATEDIFF(day,encounter.dttm, GETDATE()) < 365 | select count( * ) from encounter where DATEDIFF(day,encounter.dttm, GETDATE()) < 365 | ||
</source> | </source> |
Latest revision as of 17:03, 29 July 2014
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