USP_KPI_REVENUE_SELECTIONCOUNT_INTERNAL

            CREATE procedure dbo.USP_KPI_REVENUE_SELECTIONCOUNT_INTERNAL

            @ASOFDATE datetime,
            @TOTAL int = 0 output

            as    

            set nocount on;

            select @TOTAL = count(*) from dbo.REVENUE R
            --when the spec is loaded an sp named USP_KPI_REVENUE_SELECTIONCOUNT_INTERNALWITHIDSET will be generated.

            /*#IDSETEXTENSION*/
      where R.DATE <= @ASOFDATE