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);