USP_REPORT_DASHBOARD_DAILYADMISSIONCOUNT
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@FROMDATE | datetime | IN | |
@TODATE | datetime | IN |
Definition
Copy
create procedure dbo.USP_REPORT_DASHBOARD_DAILYADMISSIONCOUNT
(
@FROMDATE datetime = null,
@TODATE datetime = null
)
as
set nocount on;
select sum(AdmissionCount) AdmissionCount
from dbo.UFN_REPORT_DASHBOARD_DAILYADMISSIONCOUNT_BASE(@FROMDATE, @TODATE);