USP_KPI_CONSTITUENT_SELECTIONCOUNT_INTERNAL

            create procedure dbo.USP_KPI_CONSTITUENT_SELECTIONCOUNT_INTERNAL(@ASOFDATE datetime,
                @TOTAL int = 0 output)
            as    

            set nocount on;

            select @TOTAL = count(*) from dbo.CONSTITUENT C
            --when the spec is loaded an sp named USP_KPI_CONSTITUENT_SELECTIONCOUNT_INTERNAL_WITHIDSET will be generated.

            /*#IDSETEXTENSION*/